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.

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.

image

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