14,499 questions
Hi @Johnathan Simpson ,
There are two main methods:
- By using
PRINTstatement in the strategic locations in a stored procedure. - By using inline T-SQL debugger (SSMS 17.9.1 and earlier, or Visual Studio)
How To Troubleshoot A Stored Procedure
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Johnathan Simpson
586
Reputation points
What are some tips and tricks on how to troubleshoot a stored procedure?
SQL Server | Other
3 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky 26,586 Reputation points2021-04-09T15:38:32.937+00:00 -
Johnathan Simpson 586 Reputation points
2021-04-10T00:08:03.57+00:00 How do you use the inline T-SQL debugger ? I work with SSMS, and have never used this.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,771 Reputation points2021-04-09T17:12:13.107+00:00 I use a method in most of using PRINT statements around a variable @debug. Then you can turn it on and off when needed.
CREATE PROC ... @debug int = 0 AS IF @debug >0 PRINT 'stuff'-
Johnathan Simpson 586 Reputation points
2021-04-10T00:07:38.32+00:00 using a variable for debugging an dprinting when if/needed, I like it.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT 6,661 Reputation points2021-04-12T08:52:57.807+00:00 Hi,
The Transact-SQL debugger feature works with SSMS version 17.9.1 and earlier, it was removed from SSMS version 18.0. But you can install and use SSMS 17.x and SSMS 18.x side by side.
The demand for the debugger to be put back to SSMS 18 is very high on the SQL server use feedback, second only to the dark theme.
Also have a look on this similar case.
How to debug tsql code in Visual Studio since SSMS v18 does not have a debugger