G-Productions | dm_exec_sessions


	Home Microsoft SQL Server DigiMailing iRN Contact	Keyword

Views

DMV

Functions

sys.dm_exec_sessions


	This is a view in the mssqlsystemresource database. Contains one row per authenticated session on the SQL Server.

Syntax


CREATE VIEW sys.dm_exec_sessions AS SELECT * FROM OpenRowset(TABLE SYSSESSIONS)

Last revision 2008RTM

See also


	sp_checkusernotloggedin (Procedure) sp_MSadd_merge_history (Procedure) sp_MSadd_merge_history90 (Procedure) sp_MScheck_agent_instance (Procedure) sp_MScheck_pull_access (Procedure) sp_MSflush_access_cache (Procedure) sp_MSgetreplicainfo (Procedure) sp_MShelp_subscriberside_history (Procedure) sp_MSinsertgenhistory (Procedure) sp_MSlocalizeinterruptedgenerations (Procedure) sp_MSmakegeneration (Procedure) sp_replmonitorhelpmergesession (Procedure)

News


	Query a named instance Sybase+ASE+silent+install SQL 2008 R2 Deprecated procedures in SQL2008 Reporting Services item-level role definitions Create all your missing indexes Converting datetime field Start MSSQL Server Profiler at time Replicating MSSQL Server views Exploring Microsoft Sharepoint The OLE DB provider "SQLNCLI10" for linked server indicates. Mobile solar charger Oracle to SQL Server replication Cannot insert the value NULL into column Undocumented Microsoft SQL Server 2008 VMware Zoekmachine optimalisatie SQL Servers hidden objects FckEditor Flash in Ajax De hype die AJAX heet Barcode scannen MySQL; Gratis, makkelijk en snel! PHP sIFR; de combinatie tussen HTML en Flash