Timo
2004-04-13 17:15:50 UTC
I couldn't restore a SQL database on my local development PC and so executed
SP_WHO2 based on some tips found online. Not sure, however, how to
interpret the results: there seem to be four processes "using" the database,
consuming 0 CPU, associated with .Net SqlClient Data Provider, with 01/01
00:00:00 in the LastBatch column, all with a status = "Sleeping", and
identified with a particular domain user (me). What are these entries and
can they be killed?
Thanks
Timo
SP_WHO2 based on some tips found online. Not sure, however, how to
interpret the results: there seem to be four processes "using" the database,
consuming 0 CPU, associated with .Net SqlClient Data Provider, with 01/01
00:00:00 in the LastBatch column, all with a status = "Sleeping", and
identified with a particular domain user (me). What are these entries and
can they be killed?
Thanks
Timo