It would be better if you run profiler against your login and see from where that spid is gettng called up and which process is invoking such request.

MJ

http://msdn.microsoft.com/en-us/library/ms187997(SQL.90).aspx

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent...

Would like to get updates as you proceed.

MJ

Try specifying a log file under the job logging option and see if it logs helpful error message there.

MJ

How to remove a failover clustered instance (Setup)

http://msdn.microsoft.com/en-us/library/aa216166(sql.80).aspx

There is however one known issue with build 2187 of SQL Server 2000 as described here, so you may need to apply this...

You can create covering indexes in 2000. See -->http://www.sqlusa.com/bestpractices/coveringindex/

If you applied the script before database restoration then they will get mapped automatically.

MJ

Is your CPU the same as listed at -->http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/35f3f460-9168-401f-bca5-16536b6ad7fe/

MJ

Hope this works for you:

Create TABLE #db_file_information(

fileid integer

, theFileGroup integer

, Total_Extents integer

, Used_Extents integer

, db varchar(30)

, file_Path_name varchar(300))

-- Get the size of the datafiles

insert into #db_file_information

(...

From-->http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

Error Message 2:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused...

What is the edition of sql server? Also, check sql error logs.

MJ

As long as you have space on any 1 mdf and any 1 ldf file(or the drive where they are residing if max size restriction is not there) then you...

Are there any memory related errors in sql server error log?

MJ

Please do check sql server error logs and event viewer logs for any errors. As another poster has posted "check for any service restart".

MJ

Is distributed transaction coordinator (MSDTC) service started on your machine?

Check the com+ applications on the machine-->my computer (Control panel\administrative tools\Componant services\Computers\My Computer\Com+ Applications).

MJ