Antares686:

The sizes I mentioned here are the "Size" info on the Properties page of the databases.

124mb is the total size of the remote server.

227mb is only the mdf file of...

Greg Larsen: Thanks I will try this.

cstrong: I don't know about growth but what I know is we have limited space allocated and if we were to us more space...

Thanks for the all your help. I've found the solution but I need some dynamic SQL help for it. The code I've found is working itself alone but when I...

quote:

---

Not sure what you exactly want.

---

What I need is this: The categories will be listed...

nickel01:

yes they're nullable

bp:

no i don't have any triggers.

I found out something today. After changing the datatype of the column to varchar I was still getting 0 value inserted. The stored...

I just realised that I didn't selected the database from drop down list in query analyzer. The master database was selected by default. duh! 🙂

Let me be a little specific..

A compromised security is not an issue I think; and we can rule out any SUE (Stupid User Error) possibility.

I am saying that not...

Sure.

 

if exists(select name from sysobjects where name='proc_AdvertiserSignup' and type='P')

drop procedure proc_AdvertiserSignup

go



create procedure proc_AdvertiserSignup

@login varchar(100),@password varchar(50),@name varchar(200),@email varchar(200)

as

set nocount on



declare @err_msg varchar(3000)

set @err_msg=''



if exists(select ID...

Ok bkelley I'll check it out. Maybe it'll do more good for me.

I just don't get it that Snitz does this working with a more complex sql string than mine...

Thanks for the all help.

The reason I wrote this topic was a search page which gives me a lot of headaches. I was getting a "timeout expired" error. I thought...

dm:

quote:

---

3) Without knowing the queries the forum uses, this question is hard to answer. My guess would be the Topic_id...

Thanks for the code Stuart. But the problem I'm having is the "in (1,3,10)" part. The forum numbers (which forums to search - 1,3,10) will be selected by users using...

GAL0303 excellent idea. Thanks, I'll do just like you said. Also chrhedga thanks for the IN tip.

I'd like to ask your opinion about doing this on an already built database....

Antares686:

quote:

---

Coul also be another column if you pass multiple columns and oyu are looking in the wrong place.

---

August 20, 2002 at 4:54 pm