master..sysprocesses.last_batch = ''01/01/1901''

• Andrew Stanton

  Ten Centuries

  Points: 1115

  More actions

  May 4, 2006 at 6:57 am

  #91729

  Does anyone know why sql doesnt have a recorded last batch time for some spids?

  select spid,last_batch from master..sysprocesses

  will once in a while report results like this...

  307  1900-01-01 00:00:00.000 

  238  2006-04-27 15:49:08.333 

  192  2006-04-28 06:48:05.477 

  the transactions usually complete without error, but I was curious to know why this happens or if its indicative of a real problem.

   

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  May 4, 2006 at 8:30 am

  #635950

  http://support.microsoft.com/default.aspx?scid=kb;en-us;306625

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.