Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

last batch

Status
Not open for further replies.

francox

IS-IT--Management
Jul 19, 2001
26
CH
SQL 7.0 SP1 NT 4 EE -Cluster
I find some connection to SQL Server with last batch = 01.01.1900 00:00:00.
Any idea?
Thank you very much - Franco
 

Last Batch refers to the time that the last query for the connection was processed. 01.01.1900 00:00:00 corresponds to 0 in that column.

In my experience, this means that a client made a connection and logged in but then something failed before a query could be sent to SQL Server. I just kill those orphaned connections. Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top