2
votes
0answers
290 views

SQL Server Debugging: “Unable to Step. Invalid operation”

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 ...
1
vote
3answers
3k views

How do I identify slow queries in sql server?

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 ...
3
votes
3answers
1k views

Identifying “Lock Timeout” errors on SQL Server 2000

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. ...
2
votes
3answers
136 views

Are there any risks to enabling SQL Debugging

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 ...