SQL Server Performance Forum – Threads Archive
last batch =jan 1,1900
hi <br />if i see in current activity ->><img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess information<br />login time =current date<br />and last batch =jan 1,1900<br /><br />Should i make a conclusion that something goes wrong and SQL goes crazy asinging <br />default date or there is an other explanation to that?Check which spid shows that information, and if no activity kill the connection.
It could be due to mismatch of version between client and server and also locale settings. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I also saw this link on this issue:
INF: Last Batch Date is Seen as 1900-01-01 00:00:00.000
http://support.microsoft.com/kb/306625
Hope this helps.
-jrdevdba
]]>