The column waittype of master..sysprocesses table contains binary numbers.
I am looking for their codes. I know that Microsoft has published these codes for SQL Server 7 (here: http://support.microsoft.com/default...b;EN-US;244455 ), but I need the codes of SQL Server 2000.
And yes, I've checked spt_values - they are not there.
I believe, but have no proof, that the waittype values are hardcoded into the .dlls and .exes of SQL Server. I think they are treated similar to semaphores. Again, I have no documentation to back that up, but I have not seen any of the waittype values in any table.