crishna1
asked on
Sp_who2
Hi,
Where or How does the SP_WHO2 gets the information for which program the user is running?
EX:
54 sleeping NT AUTHORITY\SYSTEM HOUDB . msdb AWAITING COMMAND 31 0 05/14 09:49:55 SQLAgent - Generic refresher
55 sleeping NT AUTHORITY\SYSTEM HOUDB . msdb AWAITING COMMAND 14420526 09/03 11:26:34 SQLAgent -Alert Engine
56 sleeping ABC_SYS SPERRYWS . ABC_ENERGY18 AWAITING COMMAND 125687 09/02 18:34:08 Gas Modules
57 sleeping ABC_SYS SPERRYWS . ABC_ENERGY18 AWAITING COMMAND 5000 09/02 17:07:30 Financial Bucket
The one at the very end is programname which i am interested in.
many thanks.
Where or How does the SP_WHO2 gets the information for which program the user is running?
EX:
54 sleeping NT AUTHORITY\SYSTEM HOUDB . msdb AWAITING COMMAND 31 0 05/14 09:49:55 SQLAgent - Generic refresher
55 sleeping NT AUTHORITY\SYSTEM HOUDB . msdb AWAITING COMMAND 14420526 09/03 11:26:34 SQLAgent -Alert Engine
56 sleeping ABC_SYS SPERRYWS . ABC_ENERGY18 AWAITING COMMAND 125687 09/02 18:34:08 Gas Modules
57 sleeping ABC_SYS SPERRYWS . ABC_ENERGY18 AWAITING COMMAND 5000 09/02 17:07:30 Financial Bucket
The one at the very end is programname which i am interested in.
many thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you really wanna see what's going on, run this in query analyzer:
use master
go
sp_helptext sp_who2