Check

msdb..backupset

I would like to retrieve this info by a script. Any input?

Did you try to save your profiler in different format and modify it?

Did you check the connection setting under the SQL Server Properties dialog?

Check the maximum connections and timeout.

You need to break all connections to get the single user mode. If an account is in an application role, you cannot disconnect it. You have to disable it.

It is...

After you start your self-designed profiler, you may click File/Save As ...

Could you change the database recovery mode to SIMPLE before running reindex?

Of course, you need to change it back to FULL after completion.

Copying a backup file across internet may experience file corruption. If a backup file is corrupted, SQL Server will "feel" confused and takes a longer time than normal to return...

Yes. It is possible.

You can use sp_addlinkedserver to link each server, then modify password on each server.

Just my experiences.

The rate of a restore process is in the order 0f 40 GB/hour. Normally, it is in the range between 20 - 60 GB/hour.

To check if your restore is...

Did you try

SELECT * FROM myTable WHERE comments LIKE '%stuck%'

I would prefer to use left join in the first query. The reason is what if an employee does not have any dependent, or the data on the dependant has...

Link the remote server first using sp_addlinkedserver 'remote server'. I assume you have authority in executing the exe on the remote server.

Before seeing the error: "SuperSocket Info: Bind failed on TCP port 1433", did you change your IP? If so, the following link may help,

http://support.microsoft.com/kb/319578

The system error 21 indicates that when the logWriter would like to write logs, a device is not ready. Here is a link for the system errors. To find more information on...