I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid ...
I've found long, complicated instructions like this when googling for the answer to this question, an brief reference links such as in this post. I'm looking for a succinct a procedure as possible to ...
Our ERP software uses a SQL Server 2000 database. When we run a specific task on the software that used to take few seconds, a 300 seconds delay happens and SQL Server returns the error "Lock Timeout. ...
In our current environment, developers are not allowed to use SQL Debugging against any of the QA servers. It's not clear to me why the decision was made. What factors should be considered to decide ...