Different Status of a SPID in SQL Server and What do they mean

You can check the status of a SPID using any of these queries: SELECT   status ,*   FROM   sys . sysprocesses   SELECT  status ,*   FRO...