You can also use profiler for the same which is more accurate yet consume lots of space. If space is not an issue then go ahead with it.

17883 is raised when the UMS schedular experience a yield problem. I have noticed generally these are related to bug in SQL Server. As you said you are in SP4...,...

Even though it was successfull , I would like to know why do you want to move the system databases?

Microsoft does not support this.

Thanks Mikelyn, Preeti would you please try that and post us the update.

That will be of great help.

Hi

similar post have been there at this link:

http://www.sqlservercentral.com/Forums/Topic458759-291-1.aspx#bm459301

Please read the answer posted by dthomas.

Hope this might help you.

Thanks to all of you. I got the script from SQL Servercentral scripts and it worked perfectly.

😀

Is it possible to drop that cluster index and recreate it instead of rebuilding it.

Yes you r right SQl Server is clean. I googled this info.. hope this might help.

http://www.webservertalk.com/message1895352.html

" special this section:to use ADO recordsets instead of DAO recordsets,because DAO seems...

SQL Server 2000 I/O Basics by Bob Dorr.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

This might help :

INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2)

http://support.microsoft.com/kb/290212/en-us

Is it possible to post the SQL Server error message.

Please go to the LOG folder of the SQL Server and read the error log without any extension.

For your ref. 🙂

http://support.microsoft.com/kb/329133/en-us

http://support.microsoft.com/kb/314515/en-us

http://support.microsoft.com/kb/810969/en-us

http://support.microsoft.com/kb/821786/en-us

in that case please refer to the following KB for the

http://support.microsoft.com/kb/329133/en-us

Hi Mark and Lukaszm

Your issue may be related to this KB http://support.microsoft.com/kb/892803

Ok .. then ..got it while shrinking you receive this error. There is known issue let me check