What kind of application is running this process?

--- It is a .Net application. It is running running .....

Do you get an error message?

-- no error message. I could...

Makes sense. You mean to say, rather than restoring all the system databasess and modifying the ssystem tables to point to new server is a clumsy act and which is...

Thanks Laxmi.

Is there anything similar for log shipping ?

Since we are restoring on a new server which is currently not in use and i have taken the sql server into single user mode then why cant we restore...

Too Good! 🙂

Thanks 🙂

Thanks Steve 🙂

Thank You so much.:-)

Okay.

Thanks for the tip.

http://support.microsoft.com/support/servicepacks/sql/2000/sp3readme.asp?SD=gn&LN=en-us&gssnb=1

Is the above link is the correct one ?

Got it! makes sense.

Thanks George.

Can you provide me the link for the KB article.

Thanks,

Super!!

Makes sense...

Thanks so much Gila!:-)

Found it myself. Hope, this helps others!!

I figured out why it is happening. At server level/instance level , the NOCOUNT option is checked.

Now linked server is working for all...

Hi Gila,

As you said, i understand that since the machine is dedicated as database server and no more app's are running then there is no need to change the default...