Wednesday, December 14, 2011

Two SPIDs in sp_who2


sp_who2 is function you can use to identify who (Login) is running at what (DBName, command) from where (SPID & Host) as you can see in the following image.


If you look closely, you will see that there are two SPID columns with same values. By looking at them, they are same So let us see the coding of this.


So you would see that SPID column is convert(char(5),spid) so why on earth same column twice.

Just see the comment after second SPID.

Handy extra for right-scrolling users.

Do you agree. I am not Smile .

No comments:

Post a Comment