Currently Running Process - 2005

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ericb1 SSCrazy Points: 2354 More actions · Answer 1

this script is really great, thanks! Is there any way to add the user and/or host machine name that is running the query? (so I know who to yell at 🙂

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 2

SSCrazy Eights

Points: 9686

February 29, 2012 at 8:02 am

Nice Script .

thanks for posting here...

_orlando Newbie Points: 3 More actions · Answer 3

I added this bit to the select to get the user accout:

UserLogin = (

select

convert(sysname, rtrim(loginame))

from

master.dbo.sysprocesses

where

spid = a.session_id

),

Great script. thanks!

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

SSC Guru

Points: 76202

May 11, 2016 at 7:13 am

Thanks for the script.