(ms****@yahoo.com) writes:
My vb application is displaying an error message when it loses sql
connection. My client thinks it has nothing to do with their sql2000
server and tells me they never 'stop and start' sql services. But I
think they do. Is there a way to find out the status of sql connection
from the log? Or are there better ways?
So what does your error message say?
You could lose the network connection, if the network is flaky. You could
also loose the connection to SQL server, if there is an execution error
in your SQL Server process, which causes SQL Server to kill that process.
These execution errors (which are usually tokens of bugs in SQL Server)
exhibit themselves as stack dumps in the SQL Server error log.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp