Confused by sp_who2 (Dear SQL DBA Episode 30)

[@Aparichitha583]

Dbcc inputbuffer(SPID) - TO GET INFORMATION ABOUT PROCESS HANGING
DBCC OPENTRAN - TO CHECK OLD TRANSACTION IN DB

[@borkasiamese4617]

thank you, Kendra :)

[@sqlgeekspro3525]

Thanks Kendra for the nice explanation :)
: Dev

[@mjkhan368]

Thanks Maam