Check for any SSIS pkg or agent job running in background which drop/create linked servers and it has these RPC settings set to FALSE?

MJ

Do you want to switch roles of the primary and secondary databases?

If yes, then read Reversing Roles under http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx#EIF

HTH,

MJ

Do you have any id avaialable which is sysadmin on this instalation so that you do these single user stuff and issuing a command from command prompt.

MJ

First create a alert of type(SQL Server Event Alert) and then chose severity of 016(Misc. User Error) for all databases. Then specify message text as "Blocking Threshold" . Then finally...

Try executing the below code from management studio:

!!Sqlcmd -S Servername -E -d northwind -Q "Select * from employees" -o C:\output_file.csv -s ,

-s switch specifies the column-separator character. The default is...

Start from http://support.microsoft.com/?kbid=271509

MJ

Mani,

Try this. Connect to ur sql server in normal mode(no single user mode) and open a query analyzer window and stay in it. With this window open do the rest...

Try connecting thru query analyzer and post the error message.

MJ

Please read the attached doc.

MJ

What exactly you want to capture?

MJ

What is the eror message tht u get when u try to connect from EM? Try thru query analyzer too..

I think u r trying to do the restoration of master...

Have you tried increasing the page file size?

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

MJ

Run this:

Update dbo.ReportblCust

Set ValidMsgDisp = Source.ValidMsgDisp

From

ReportData_DPS.dbo.ReportblCust Dest Join

ReportData_DPSTest.dbo.ReportblCust Source On

...

Invoke the second job on completion of first job by calling it under second step by making use of sp_start_job stored procedure.

http://technet.microsoft.com/en-us/library/ms186757(SQL.90).aspx

HTH,

MJ

Have you tried steps mentioned under http://kendalvandyke.blogspot.com/2008/11/delegation-what-it-is-and-how-to-set-it.html

MJ