sql server programming: Hi,

If the client is disconnected abruptly from the server, from where do we get
the log?

how do we get the data from the server that the particular client is
disconnected abruptly?

Thanks

Hi

You will need to code your application to handle errors returned from the
calls that interface with the database e.g. if you use ado check out the
section "Handling Errors and Messages in ADO" in books online and the sample
application "C:\Program Files\Microsoft SQL
Server\80\Tools\Devtools\Samples\ADO\VB\Intro" also check out the ADO
programmers guide
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdconerrorhandling.asp.

You may find more information regarding the reason why the connection failed
in the SQL Server error log, the event log on the SQL server server, or the
clients event log.

If disconnected you will need to re-connect and start your processing again.
SQL server will usually at some point detect your previous connection has
been aborted and rollback the work.

HTH

John
[quoted text, click to view]