Since Guids are unique anywhere you find them, they make a good primary key.The trick is to create them where and when you need them using the CoCreateGuidAPI. You can
If you have ever monitored any blocking problems in SQL Server, you know that sp_who only shows you the spid (SQL Server’s internal Process ID) that is causing the blocking