query on sysprocesses...

I was trying to findout processes which are running for long time and came across few entries in sysprocess where Last_Batch column shows '01/01/1900'

It is a usual practice for SQL coders to put a default date like this if they don't have a valid date, does sysprocesses table does the same thing ?Hi

It is not the best, but this table dates back to when SQL Server was produced by Sybase. A long history of backward-compatability. Microsoft has changed the system tables in SQL Server 2005 (sys.dm_exec_sessions in this case)

Regards
Mike|||No, this is not the way I would have done it. This is a token date, which more or less means the engine is saying, I don't have information about when this process started. I would rather see NULL here, though the engine should be able to figure out when it first saw this process (?). I can see novice DBAs reaching for the panic button, hey, this process has been running for over a century, we'd better kill it! wrote in message news:b9193c83-2128-40b6-8023-67fac4611e91@.discussions.microsoft.com... >I was trying to findout processes which are running for long time and
> came across few entries in sysprocess where Last_Batch column shows
> '01/01/1900' >
> It is a usual practice for SQL coders to put a default date like this if
> they don't have a valid date, does sysprocesses table does the same
> thing ?[:(]
>