[coding, debugging, and troubleshooting with Microsoft Technologies]
Translate This Page
Translate this page
Browse by Tags
Tagged Content List
Orphaned Locks - Idle Session - and XACT_ABORT
Sometimes you might see a situation where a session is holding locks, blocking other sessions for an extended period of time, but does not have an active request and appears to be Idle. This can happen in a few different scenarios, but here we’ll outline one scenario and how being sure to use XACT_ABORT...
8 Oct 2012
How do I set a breakpoint in a CLR Stored Procedure already deployed and running on a live SQL Server and debug is using Visual Studio?
For information on setup and debugging a CLR stored procedure in a direct-debug scenario by “stepping-through” the code from within Visual Studio, OR by using a test TSQL script from with Visual Studio, refer to the following MSDN article: http://msdn.microsoft.com/en-us/library/ms165051...
7 Feb 2010
Page 1 of 1 (2 items)
© 2015 Microsoft Corporation.
Privacy & Cookies