http://sqlserver.ro/forums/17/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/45.aspxFri, 28 Apr 2006 14:04:39 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:45xmldeveloper0http://sqlserver.ro/forums/thread/45.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=45<P>One of your users' connection is blocked by another one. What options do you have to get the session id of the blocking connection ?</P> <P><A title="You can use the Activity Monitor from SQL Server Management Studio (Process Info page) or the new Dynamic Management View sys.dm_exec_requests (blocking_session_id column)" href="#">Place the mouse cursor HERE for the answer</A></P>