Yep, that works, thanks. Did not mean to offend. The G was a typo

thanks

JIM

Nope. sorry but you have sp. in there and no AS for sp. GTry running it yourself

But the question was, and is how to get it from sys.dm_exec_sessions. You are joining to the sysprocesses which in deprecated by MS SQL Server 2012 to the sys.dm_...