I assume that you use backup device. Did you check if all 3 members are there?

Based on the explanation by Microsoft, it is an error due to Invalid parameter in DB-Library function reference. It means that either you do not provide right number of variables,...

Possible solutions:

1. Service Pack issue:

http://www.windowsitpro.com/Article/ArticleID/43010/43010.html

2. Application issues:

http://www.jguru.com/faq/view.jsp?EID=219416

http://sqlserver2000.databases.aspfaq.com/why-does-enterprise-manager-return-invalid-cursor-state.html

I cannot see from your script that it is used for restoring a database from one server to another. Did you try to use mapping drives?

If no one else changes the data while you ran your queries, you may check if the data is corrupted.

You may run DBCC MEMORYSTATUS to memory usage. If memory is not in a good shape, you may try to run

DBCC DROPCLEANBUFFERS

DBCC...

I would like to bet the locks. I would like to try sp_who/sp_who2 to find the locks if I were you.

Remove the first left parenthesis after SELECT.

You did not specify your case in detail. Here is a link, which may be helpful.

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

Try

CHARINDEX ( expression1 , expression2 [ , start_location ] )

Jeff:

sysinfo does not work if we have multi-thread.

Many thanks for your input.

Thank you very much for your prompt reply. Personally, I do not think we can roll back to a lower service pack. A system database cannot be rolled back. Even restoring a user...

Adam:

The approach you recommended helps only after installing SQL Server. In reality, we can go to the Device manager to find the number of processors (I just confirmed it). The data...

Thank you very much for your input. But this script may not be able to provide a correct result. I ran it against my own PC. It returned 2, but...

As long as you can register an SQL Server from your EM, you should have no problem at all to link any SQL Server.