It's been a while since I tried this so I'm not sure if it will work for you, but I would add the column and make it nullable. Then...

I think there is a script in the script library that will kill all connections in a database. Just search for kill users, or something like that. If...

First, thanks for the reply Andy.

Second, I haven't tried it yet, but I think that I can do it with odbc. I've set up the dsn and see it...

Thanks,

It worked great.

Tom

If they are using cdonts for mailing you should check to make sure they are cleaning up the objects correctly in the stored proc. You can also change the...

Have you tried running profiler and looking for missing statistics?? I would give that a try. Also on some of the slower running queries have you looked at...

Look up sp_spaceused in books online. I think that will give you what you want.

Tom

Look up sp_spaceused in books online. I think that will give you what you want.

Tom

Try to backup to a UNC drive. Also are you running the service accounts with a domain account. Did the person that installed sp4 change the account with...

I succesfully changed the commandterminator, but that made know difference. The error message: incorrect syntax near "go".

I'll keep on trying.

Thanks

Tom

The commandterminator property is set to "go". But it certainly doesn't like the go's in the script.

Just so you don't get down, Your sample code is a big help...

I copied your code for the section I am having problems with. Here is the line that won't run the entire script:

oDB.ExecuteWithResultsAndMessages sScript, , sMsg.

I get an error...

Somebody correct me if I'm wrong, But I think that you should drop all non-clustered indexes before droping the clustered index. Because the clustered index keeps the data in...

I'm not 100%, but I'm pretty sure that sqlserver sp2 installs mdac 2.71.

You might want to try installing the latest version of the mdac.

Tom Goltl

How many different versions of data are you talking about. Have you thought about using a partitioned table(view)? Sounds like that may provide a possible solution for you.

Tom

...