All geek questions in one place

How to debug stored procedures on SQL Server 2008 without CLR?

How to debug stored procedures in SQL Server 2008 Management Studio?

I try to put a breakpoint on the SQL query, and then click on the debug start button, but I get an error that debugging cannot be started on my machine:

Debug cannot be started at <machine name>.

I do not want to use CLR debugging. How to debug stored procedures?

+6
source share
2 answers

Type exec YourStoredProcedure . Place a breakpoint next to it. Click the green (debug) arrow next to the run button. The debugger should start and hit the break point. Press F11 to enter your stored procedure. See the debug menu for more details.

Here is a very detailed blog post: T-SQL Debugger for SQL Server 2008

+9
source

try

 TRY()... CATCH()... METHOD

Read online tips based on your SP

0
source

Source: https://habr.com/ru/post/888039/

More articles:


All Articles