When you are creating the maintenance plan in SQL 2000 Enterprise Manager the "Reorganize data and index pages" option under the Update Data Optimization Information, is a little tricky.

When...

Even I could find that on some of the production servers. As Gail rightly mentioned they are system spids.

You may find this article useful in resolving deadlocks.

The easiest way to recover a lost database is to RESTORE it from previous backups.

Yes you cannot. Here is what Microsoft documentation states

Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the...

As suggested, I feel Snapshot Replication meets your requirements.

Rebooting a Server will free up the resource utilization on the box whereas restarting the instance will do the same for the SQL Server instance.

Not sure though, how it...

Get the SPID of your session and DBCC INPUTBUFFER of your session ID should give you the details.

If you have the resources, you may also spread the data files of those databases on different LUNs to boost performance.

You may find this bulletin useful.

You may create table and insert the result into it. Here is an example

create table xpinfo

(

column1 varchar(500),

column2 varchar(500),

column3 varchar(500),

column4 varchar(500),

)

insert into xpinfo exec xp_msver

go

select * from xpinfo

Please add an output file to the Job step of the job which is failing. It would give more details of the job execution.

[Edit] Adding to this, SQL Server 2005...

Even though this post is for SQL 2000, check if it helps.

You may find this white paper useful

You may want to cross check the column mappings. Please refer this article