Andy - Not supported by MS when you have multiple log files. Don't have a clue as to why but, not supported.

David

It should look something like this. I changed your column names so that I could use them myself when writing this. Ultimately this is called Correlated SubQueries and is based...

Sorry, didn't read the full description this is 6.5. I believe the sp_detach_db solution should still work.

David

You can detach the database and then reattach with the new locations. See BOL for reference in T-SQL or EM if SQL 2000 (look up sp_detach_db and sp_attach_db)

Hope this...

Ultimately, you have the answer. It's either the backup or nothing. Everything that I have seen from MS verifies what you have stated and even trying to fool it by...

Here is a recent oops for all to enjoy. My expense.. have fun.

Upgrading a server to Windows 2000 and SQL Server 2000 and additionally expanding the drive sets for the...

Yes. Glad to help.

David

Anytime that you are working with Send Mail from a DTS package there are four points to check as follows;

1. The job that is running the DTS package owner.

2. The...

Check out article Q303411.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q303411

Hope this helps.

David

I'm afraid I will have to call in the likes of Andy Warren for this one. More his style. I am in the process of learning how to use ADO...

My pleasure and I too have been there. Glad to help.

David

Try changing the default options (deselect "use default options" click on options) and removing the check in "copy database users and database roles" option. Also deselect any of the other...

That's where the job comes in. Even though you only want to execute this from a stored procedure, it is not possible to call the DTS package from T-SQL directly....

Sorry, should have been more explicit. It sounds like you will need to creat a DTS package that will manage the table, index, etc moves and then schedule that package...

I personally use Steve's second suggestion, sp_start_job, and it works great. Works great across linked servers as well.

David