Saturday, February 25, 2012

SCREWY LAST BATCH DATE

Using SQL2k EE SP3
There's a spid in the activity monitor that has a Last Batch date of
1/1/1900 12:00AM however, the logged In date is recent. What could cause
this to happen?
tia
--
MGMG,
Perhaps because it has logged in, but never executed a batch. 1/1/1900
12:00 AM is datetime 0, since last_batch is a non-nullable column.
I have seen this with some applications where 1 connnection will display
this behavior as other connections do the actual work.
RLF
"Hurme" <michael.geles@.thomson.com> wrote in message
news:5EEF3B0D-CA4D-43C8-84DB-88AA8614241A@.microsoft.com...
> Using SQL2k EE SP3
> There's a spid in the activity monitor that has a Last Batch date of
> 1/1/1900 12:00AM however, the logged In date is recent. What could cause
> this to happen?
> tia
> --
> MG

No comments:

Post a Comment