April 13, 2011 at 7:46 am
I have a process_id, how can I find out, who is the user that ran the procedure?
Thank you
April 13, 2011 at 7:51 am
sp_who2?
sys.sysprocesses?
April 13, 2011 at 9:10 am
After the fact, when everything is done, without a trace file available? You can't. If you have a trace running, you can use that to get the user (assuming you're collecting that column) from the processid. If it's actively running you can do what the resident Ninja said.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2011 at 9:19 am
Nicely said Gail :hehe:.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply