Posted by Erland Sommarskog on 06/28/05 00:49

(csomberg@dwr.com) writes:
> SQL Server 2000
>
> Just curious - was wondering why some SPIDS are left hanging out there
> for up to several weeks. There are no errors or anything. It looks like
> normal processing.

Without seeing the output from sp_who2 or similar, it's difficult to
say much useful. But if they are spid < 50, they are system processes.

If they are > 50, they are user processes, and apparently the client
that opened this connections are still clinging to them. The hostname
and prog_name columns in master..sysprocesses may give some clues.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]