I tried the first one and there is still some kind of syntax error. I tried the 2nd one and it seems to work. I would prefer no cursor, but...

I try this...

DECLARE @cmd1 varchar(100)

SET @cmd1 = 'ALTER ? SET SINGLE_USER'

DECLARE @cmd2 varchar(100)

SET @cmd2 = 'DBCC CHECKDB (''[?]'',REBUILD_REPAIR)'

DECLARE @cmd3 varchar(100)

SET @cmd3 = 'ALTER ? SET MULTI_USER'

EXEC sp_msforeachdb @command1 = @cmd1,

@command2=@cmd2,

@command3=@cmd3

And...

We have a lot of dts packages. I would like to just run an update statement for all packages but not sure which table that name is in.but thank you...

Is it possible to set this up with multiple statements?

I'd like to set to single user mode, run a repair and then reset to multi user. I'll be trying a...

I cannot reinstall since there is a newer version. I am however able to use configuration manager when i log onto the server as service sql. Where do I set...

I get the same error message above.

Yes, it exists, but when i try to open it gives me the same error message.

You are awesome! Thank you so much! You should post as a script in the scripts section.

Thanks again!

thats great. Is there a way to add the alter table add constraint in there?

I'm sorry, this is for sql server 2000 and I need a script that will create the alter statements to add them to the database in case of loss.

I'm still having the same problem, however, I have the client on my own desktop along with the 2000 client and the lookups work. I'm going to try installing the...

ok, thank you so much for your help.

We have not given them access to anything but the dts import/export. They do adhoc imports and exports to this database. That's all they know how to do.

I'm not finding where the scripts are being saved, I tried both local and on the server by puttingin the path i wanted it saved in

Looks like each section must be run separately