INF: Last Batch Date is Seen as 1900-01-01 00:00:00.000

This article has been archived. It is offered "as is" and will no longer be updated.
Summary
When you review the last_batch column by using Current Activity in SQL Enterprise Manager, or the master.sysprocesses.last_batch column when you use SQL Server Query Analyzer, you may see the Last Batch value as 1900-01-01 00:00:00.000 for a connection (system server process IDs [SPIDs]). The Last Batch value appears as 1900-01-01 00:00:00.000 because there is a connection (SPID) that has been made through a client that makes a connection without any remote stored procedure call (RPC) activity on the computer that is running SQL Server. The connection does not issue any Execute commands. Because the last_batch column is typed as datetime, and a value is absent, the value is stored as the default datetime value (which is 1900-01-01 00:00:00.000). The last_batch column is updated with the datetime of the last time a client process executed a remote stored procedure call or an Execute statement. Most client technology issues at least one RPC or Execute statement when the connection is made. If the client technology does not issue at least one RPC or Execute statement when the connection is made, then there is possibly no "last" RPC or Execute statement. If there is no "last" RPC or Execute statement, you will see a last_batch value of 1900-01-01 00:00:00.000.
More information
To examine this behavior, you can use the Isql.exe program that is provided with Microsoft SQL Server 6.5 to make a client connection to the computer that is running SQL Server. Clear the Automatic Ansi to OEM and Use International Settings default options in the client configuration utility. Next, make a connection to the computer that is running SQL Server. Note that the last_batch value is 1900-01-01 00:00:00.000 until you use the connection to execute a statement.
Properties

Article ID: 306625 - Last Review: 01/16/2015 23:22:36 - Revision: 4.0

  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • kbnosurvey kbarchive kbinfo KB306625
Feedback