Does it happen constantly or sporadically?

If constantly, check your hardware.

If sporadically, check locks, scripts, stored procedures, ... all of software.

I do not think you can do it in Windows. Read the last paragraph in this article.

http://www.microsoft.com/technet/scriptcenter/guide/sas_scr_klwf.mspx?mfr=true

In the first run, an estimated execution plan is saved in the cache of your machine. When you have a second run, it will be faster.

Having a window-level defragment while SQL Server on is not recommended. It may crash your server.

I do not think shrinkfile command generate a large size of transaction. But some commands may generate a large size of log file, such as manipulating indexes.

Are you sure...

I may not have any chance.

However, you may try the following approach only if all of your transaction logs stay since creating msdb.

Have a transaction log backup;

Re-create a...

If you did not audit, I do not think you can.

You can set the database options to AUTOCLOSE. Then you will know when a database is connected from SQL logs....

Computer Properties;

Click Performance Settings under Advanced tab;

Click Change under the Advance tab;

It is correct in syntax, but the user must be created in master database.

As described in my question, the user does not have any other access to master database....

I am behind you.

Try something like

EXEC master..xp_cmdshell 'ECHO myMessage > C:\myFile.txt'

If you would like to manipulate data among datbases, you may have to follow the 4 name vention, such as

databaseName.ownerName.tableName.columnName

I do not think you can.

In my memory, when you create a primary key first time, it will be clustered if there is no existing clustered index. Are you sure...

How about

sp_who2 active

SELECT * FROM master..sysprocesses

Paul is right. You have to restore your database to 7X first, backup again from there, then restore it to SQL 2000 (I am not sure if it will be...