May this link help.

http://msdn.microsoft.com/en-us/library/ms188783.aspx

How about Profiler in SQL 2005 and PerfMon in OS?

Check security;

Check Job Type in each step;

Check log output file if there is any. If there is not, create one, which will provide detail information.

It seems a security issue. Check whether or not your DTS package has authority to implement its tasks.

If you are asked how to find the max number of connections, right-click the instance, choose Properties, you can find it under the connection tab. But you may need sa...

Let me try first.

Backup Set - records all information on each single backup and restores, such as backup time, lsn, and type.

Backup Device - records all informaiton on the backup...

I do not think changing sa password will affect your scheduled jobs.

The failure of your jobs may have some other reasons. Check SQL logs and see whether or not you...

I do not think you can in SQL 2000 unless you write your own code. SQL 2005 has pivot feature, which may help.

Please correct me if anyone has any different...

How about using VBScript? You can trigger the script from your T-Script.

http://www.microsoft.com/technet/scriptcenter/scripts/hardware/default.mspx?mfr=true

You can.

What you cannot is that you cannot recover to a time point during your bulk insert.

Here are my inputs.

1. Does it lock database and runs the shrink statement.

Answer: It does not lock the database, but may lock a table in shrinking a database.

2. at...

Did you check the sys.sysservers table in master?

You cannot delete duplicates directly from a table unless you would like to delete rows, which are duplicated.

Instead, you can modify your table design, such as add a new column...

Did you try the following syntax?

SET TRANSACTION ISOLATION LEVEL

{ READ COMMITTED

| READ UNCOMMITTED

...

It never happened to me. Try to include the four name structure in your queries if you are not in the right default database.