select '' UNION

SELECT DISTINCT state

FROM gl_territory

you can't truncate a table variable. you could either use a temp table or just simply create a new table variable and use it and just let them both fall...

declare @i as int

declare @sql varchar(20)

set @i = 101

while (@i <= 300)

begin

set @sql = 'kill ' + cast(@i as varchar(4))

execute (@sql)

set @i = @i + 1

end

I don't think it is, but I'm not 100% on that. Also, task manager will not show the correct amount of memory being consumed when AWE is on - you...

you need to enable AWE to use all your ram. Be sure to add the lock pages in memory permission to your service account.

we run on R2 SP2 just fine, haven't had any issues

OK, I missed that you are using SQL 2000. It would work in 2005 even if the logins are mapped to users in the database. You should just upgrade and...

does it fail with the same error using native backups?

I don't understand why you cannot drop them and recreate them.

Associate in computer information systems. Also have my MCP on sql administration.

I am also a home brewer, but no formal education there:D

add a new job step. In the Type dropdown, select sql server integration services package. then you need to fill in the appropriate tabs. what you will fill in may...

That works - thanks a bunch. seems like I tried that one, but I must have had something wrong:)

of course if you choose to do the drop db method, always a good idea to grab a backup first.

yeah, It's been a while since I had to do that, but I believe you would have to stop sql server. move the files. start sql server using traceflag 3608...

I'm about out of ideas then, short of stopping the sql server if that is a possibility.