How to debug SQL code

In this video I'll walk you through the steps of debugging SQL code particularly stored procedures using Microsoft products like SQL Server, SSMS and VS 2019.

[zdenekniederle]

It worked for Stored Procedure and Functions but I want to debug trigger. Its not working. Can you explain how to debug a trigger

[venkateswarluguditi]

Superb..thank you for making this type of video which Is useful to someone.. keep going...

[lebza_teza]

Wish I could like this a 100 times...THANK YOU

[kevinstrickler]

Thanks, I was confused by the lack of a debugger in SSMS but this cleared it up.

[DeepakMishra-enbt]

You are GREATE sir. Got new Idea to debug sored procedure. Thanks a lot. Please provide some more ...

[mohdotnet]

Thank you for sharing this.
It is true one learns something new everyday. This is a key tip that will benefit many aspiring developers.

[nairoandrescuadradolara]

Thanks men! I don't have the option about depuration in SQL, but with this video I can debug my sp

[donaldcorbin]

Fantastic! This is what I've been looking for. Thank you Roozbeh!

[rezamohamadzadeh]

Thanks rouzbeh. It was very useful for me.

[fkbey]

Thank u sir.
Can i use this debuggin tool for scalar or table function too?

[BlueBeliever]

Thank you for the video. I'm still having an issue though. When I put a break point inside the stored procedure it says "The breakpoint will not currently be hit. Invalid line number specified with sql breakpoint.", therefore I can't step through the stored procedure code. Any thoughts on how to fix this?

[rodgdl]

Gracias, me sirvio bastante, aprendi algo mas hoy.

[lancewilliams]

Well, it appears our company has the debugger locked down tight. Any other suggestion on how to debug a procedure, especially when only testing a small portion of it, without having to copy the variable declares around????

[SimpleExcelVBA]

Do You know why Microsoft erased debugging from Management Studio?

[nmarks]

Thank you very much indeed.

Subscribed.

[stamhaney]

When I try to debug I get the following errors:

Failed to start debugger. An exception was generated: 'The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'.'

Or this:

Failed to start debugger. An exception was generated: 'Data is Null. This method or property cannot be called on Null values.'

Does debugging SQL need any other special permissions?

[SeongYoonHuh]

Thank you for your Information, I was really helpful. have a good one :)

[amitkumarvit]

What kind of permissions/rights required to use DEBUG ? As a developer I cannot have SysAdmin server role assigned to me.. Is there any other way to debug the SPs ?

[iwanttohehe]

i'm running SQL 2016 SP2 on a remote server, VisualStudio 2017(SSDT) locally. Withing VS when i 'execute without debugger' sql code runs fine, but when i 'execute with debugger' i get message "Unable to start T-sql Debugging. Could not connect to computer 'REMOTE_SQL_SERVER'. Remote debugging is not supported". Is there some settings locally or remote that needs to be enabled to support remote debugging?

[gvozdenradicevic]

Thank you for sharing.

I tried this in VS 2022 with sql server 2019 and 2017 but it doesn't work.