SQL Server 2008 - Find current sessions using DMV - sys.dm_exec_sessions

If you need to find out who currently has an open session on your server via T-SQL in SQL Server 2008 you can use the 'Dynamic Management View';   sys.dm_exec_sessions

Example code for sys.dm_exec_sessions:

The WHERE clause ensures that system processes are either included or omitted.

sys.dm_exec_sessions returns one row per authenticated session on SQL Server.

Further Reading:

http://msdn.microsoft.com/en-us/library/ms176013.aspx

http://sqlavenger.wordpress.com/2011/05/19/back-to-the-drawing-board/

List user processes:

select *
from sys.dm_exec_sessions
where is_user_process = 1

List system processes:

select *
from sys.dm_exec_sessions
where is_user_process = 0

How to enable xp_cmdshell using sp_configure - SQL Server

The xp_cmdshell option is a server configuration option. xp_cmdshell enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.

To allow advanced options to be changed:

EXEC sp_configure ‘show advanced options’, 1
GO
 ////////////////////////////////////////////////////////////////////////////////

To update the currently configured value for advanced options:

RECONFIGURE
GO
 ////////////////////////////////////////////////////////////////////////////////

To enable xp_cmdshell:

EXEC sp_configure ‘xp_cmdshell’, 1
GO
 ////////////////////////////////////////////////////////////////////////////////

To update the currently configured value for xp_cmdshell:

RECONFIGURE
GO


/////////////////////////////////////////////////////////////////////////////////
Useful Links:

Using xp_cmdshell