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
