SQL Server Performance

last batch =jan 1,1900

Discussion in 'General DBA Questions' started by NewDBA, Nov 12, 2003.

  1. NewDBA Member

    hi <br />if i see in current activity -&gt;&gt<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?
  2. satya Moderator

    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
  3. jrdevdba New Member

Share This Page