What is your build number?

Take a look Concurrency enhancements for the tempdb database article applies to sp3...

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

You can script trace from profiler...

When you open profile...

Click on File/ScriptTrace/sql2000 and save the script on your desktop as trace file...

Open the saved trace file in QA make it a...

select cast(LastLoginDate as varchar(11)) as 'date', 

       datepart(hh, LastLoginDate)as 'hour', 

       count(1)as #Buyers

from Buyers

Group By cast(LastLoginDateas varchar(11)), 

         datepart(hh,LastLoginDate) 

Order By cast(LastLoginDateas varchar(11)), 

         datepart(hh,LastLoginDate)

What do you mean by step?

Did you add the precedence in your dts package between your tasks?

SA can do anything on the sql server not on the servers in the domain..

Is SQL agent service using domain account or local account?

If it uses domain account make sure...

If three tables has the same columns you can write a union query to copy the data to one text file..

select * from table1

union all

select * from table2

union all

select *...

Check http://www.sqlis.com/

http://msdn2.microsoft.com/en-us/library/ms141711.aspx

I don't think you find the examples as you needed but you can make use of other samples...

If you get the backup from defferent place or taken by some one and don't have any info...

Always better to make use of the following commands to get the logical...

Instead of using builtin sql log shipping you can write your own log shipping script...

1.Backup the file to local disk 

2. Zip the backup file...

3. Copy the zip file to other server...

4. Unzip...

Enable the trace flag 1204 to write the deadlock information to sql error log...

You may not get completed dead lock info in sql 2000 profiler.

http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp

http://www.sql-server-performance.com/deadlocks.asp

Backup Restore is one way free way...2000--->2005...

If you want to go 2005---->2000... You have to take side roads with may stops...(Export/Import)...

1. Create new db...

osql -S<Sql InstanceName> -E -Q"Backup database pubs to disk = 'c:\pubs.bak' with init"

See BOL for more details...

Check the AT command in widows help...or you can check in control panel for...

I guess you are using the xp_cmdshell to execute the dts package from the procedure...

use SET NOCOUNT ON also inside the proc...

xp_cmdshell 'dtsrun /S... /E /N...',  no_output

See BOL for details...

Try this... I am not sure it is accurate or not..

exec sp_MSindexspace <Table Name>