Who is logged in MS SQL Server?
Who is logged in MS SQL Server?
EXEC SP_WHO
It’s returned the information about current users and processes.
SPID : The system process ID ,50,51,52,53,99,100 .etc
ECID: The execution context ID of a given thread associated with a specific SPID.
Status: The process status. i.e background , sleeping , runnable
Loginame : The login name associated with the particular process. i.e. SA
Hostname: The host or computer name for each process. i.e. :CMP55
Dbname : The database used by the process. i.e. - master,msdb,etc
CMD: The SQL Server command executing for the process. : i.e. : TASK MANAGER ,AWAITING COMMAND,SELECT
Do you want to kill processes?
KILL 53
