Use sp_who to report information about current users and processes on Adaptive Server:
sp_who [loginame | "spid"]
where:
loginame – is the user’s Adaptive Server login name. If you provide a login name, sp_who reports information about processes being run by that user.
spid – is the number of a specific process.
For each process run, sp_who reports the security-relevant information for the server process ID, its status, the login name of the process user, the real login name (if login_name is an alias), the name of the host computer, the server process ID of a process that is blocking this one (if any), the name of the database, and the command being run.
If you do not provide a login name or spid, sp_who reports on processes being run by all users.
The following example shows the security-relevant results from executing sp_who without a parameter:
spid status loginame origname hostname blk dbname cmd ---- ------- -------- --------- -------- --- ------ ------------- 1 running sa sa sunbird 0 pubs2 SELECT 2 sleeping NULL NULL 0 master NETWORK HANDLER 3 sleeping NULL NULL 0 master MIRROR HANDLER 4 sleeping NULL NULL 0 master AUDIT PROCESS 5 sleeping NULL NULL 0 master CHECKPOINT SLEEP (5 rows affected, return status = 0)
sp_who reports NULL for the loginame for all system processes.
