Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determining Who is Doing What

Status
Not open for further replies.
racskelly

racskelly

IS-IT--Management
Apr 19, 2007
37
CA
is there a SQL query I can run to determine which users are currently running some process on my server?
 
Sort by date Sort by votes
sp_who

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
thanks...george.

I notice when I run ISQL it cuts off most of the top part..is there anyway to capture and dump all the data in iSQL?
 
Upvote 0 Downvote
never mind I figured out how to do it..

have you any experience with sp_who2 or sp_who3
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

holdahl
  • Locked
  • Question
check if database server is running
Replies
1
Views
133
dbalearner
dbalearner
atlachar
  • Locked
  • Question
Issue with comma seperated list
Replies
0
Views
64
atlachar
atlachar
holdahl
  • Locked
  • Question
resource usage when doing update statistics
Replies
1
Views
39
PDreyer
PDreyer
ipalanisamy
  • Locked
  • Question
Is there a command in Sybase similar to MySql 'show processlist'
Replies
3
Views
120
PDreyer
PDreyer
nyck
  • Locked
  • Question
sybase15 ASE issue
Replies
0
Views
55
nyck
nyck

Part and Inventory Search

Sponsor

Back
Top