Hey,

We have the same type of requirement, I have automated the process using OSQL utility and .bat file and I is running successfully.

go through the below URL for more...

There is a problem with the network...Please check that

Are you able to ping the DB server from app server..

If it is daily work..., You can go for tool redgate sql compare http://www.redgate.com.

There is trail version to compare the data..

I was using in my previous company it is too...

as you said that is true..thanks for the info

I really appreciate your sharing the knowledge.

I am trying to find the SQL Server Errorlog messages while moving the sql server resources from one node to the other node.

I would like to see the sql...

Hi

Thanks for the help, My concern was that... We have cluster environment and we expect sql server should be up and running 24/7.

When we asked the other team to...

Hi All,

Thanks for the help...

If you are reading from .net application go through the below url

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

http://www.akadia.com/services/dotnet_load_blob.html

Are you using SQL Server 2000 / 2005?

Are you calling this sp from front end application like c#.net or vb.net code etc.. ?

the box is production box where we support

network admin stopped the sql server service then

this message appear and I could see the message sql server getting stoped due to stop...

I am using SQL Server 2000 and I am seeing this message for different users i.e same message is showing for 10 different users different database.

After that I could see the message

SQL Server is terminating due to 'stop' request from Service Control Manager.

with RAISE ERROR we can the error message to SQL Server Error Log,

But how can you delete the logs from SQL Server Error Log.

I was not aware of this point,

DNA thanks for the info....

hello

there is no edition called SQL Server 2005 MSDN edition.

Go through the below URL.

http://www.microsoft.com/sqlserver/2005/en/us/editions.aspx

I believe MSDN will come automatically when you install the SQL Server 2005