<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlserver.ro/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>It has been 3 years and it finally happened - correct usage of sys.dm_exec_sessions to retrieve user sessions</title><link>http://sqlserver.ro/blogs/cristians_blog/archive/2008/01/14/it-has-been-3-years-and-it-finally-happened-correct-usage-of-sys-dm-exec-sessions-to-retrieve-user-sessions.aspx</link><description>Since SQL Server 2005 in all the demos (even in Microsoft demos) involving sys.dm_exec_sessions DMV I saw this usage for retrieving user sessions: SELECT * FROM sys.dm_exec_sessions WHERE SPID &amp;gt; 50 This comes from SQL Server 2000 where you could select</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator></channel></rss>