Did you check if someone was using this database?

Some system stored procedures cannot be used in triggers. However, is it possible to put copy the scripts into your triggers? I am just curious. Other inputs?

I agree about the point the difference, if there is, hardly comes from out of sync. I do not mean it never happen. Anyhow, applying a hot fix should not...

Also,

check the recovery mode of related databases;

Run

BACKUP LOG myDB WITH NO_TRUNCATE

before running your DTS on related databases.

Information on DTS are saved several tables in msdb, such as sysdtsXXX. You may assign users to access to these tables.

I do not think you can revert SQL 2000 SP4. Applying a new SP does not simply apply changes in master and msdb in general. It includes many changes in objects....

How about this one?

http://www.xplg.com/home/products/xpologSnapshots.jsp?gclid=CMLO_cr32ogCFSjOJAodR2snpA

You need to get privilege to do it. Or you may ask sa to do it.

You can simply check the proper checkbox in the properties of your SQL Server....

What is the recovery mode of your database? When you reindex a database, a large amount of transaction log will be created. You may change the recovery mode to either...

In the reindex process, existing indices are dropped. The, new indices are created.

Is there any other approach beside assigning passwords to DTS packages? Using password on DTS packages is not our preference.

Would some like to summarize the difference between a registered SQL Server and a linked SQL Server?

I did not notice the top was truncated without notice.

As a comparison of mixed mode, a native mode should be SQL Server authentication.

That is my point. In order to not lock data page, should not we use the hint NOLOCK?

Both performance and backup may benifit from multiple file groups. But it may not true vice versus. As in my previous post, you may know the purpose why you have...