Debug Stored Procedures in Visual Studio

Debug by stepping through stored procedures in visual studio. Learn how to change values at runtime and create update scripts based on your changes, set breakpoints, watch values, and get the results you need.

[DataVids]

Great comment from Malcolm on Facebook: Normal VS debugging leaves an open active transaction as it processes the code.
So never use in production, as you risk locking other queries.

Also, the small print on VS Community Edition means it can be used for production work, only Training, Learning and not for profit organisations (with limitations)

[tem_vremenem_v_kanade]

By far best vid on the subject. Thank you!

[yonatandaniyel]

As of 3/23/2022 the bug is not fixed!! Damn it, I am so angry at microsoft! THey refused SP debugging in SSMS and now VS 2022 doesnt have proper SP debugging either!

[chrise]

Deleting VS 2022. Piece of buggy shit. Stick to 2019 until microsoft gets better at software.

[lozn]

Why isn't there a tool for foolproof repair that cannot remotely debug stored procedures, and a tool for foolproof repair that cannot be used in the Microsoft Store? AI learning? It's a bit ironic that as Microsoft officials, we should provide such tools. As users, it's difficult for us to solve some headache problems. We're not designers

[beingSenpai]

can anyone help me when i hover i wont see any values and when i try to see through quick watch it shows error

[biblefirst]

I want to be able to put a breakpoint on all my stored procedures and run code and just see which one gets hit. Is that possible ?

[WoodworkingChimp]

Can this process be used to debug a trigger on INSERT, UPDATE or DELETE?

[tusharkuware]

I found this video very useful for myself

[bolittos]

I want do it with my remote server no local server

[gilisaac]

Muito Obrigado amigo, você é um amigo!

[itsoverat]

Thanks so much!
I learned a lot watching this.

[Norman_Fleming]

Thank you for this video. There was a time several years ago where you could step from debugging VB code into the stored procedure and hit the breakpoints in there. Seem to remember you had to hit the SP once before you could set the breakpoint in it. Anyway, seems like they have been taking things away to bring it back later. 'Hot reload', lol you mean debug and continue. Anyway, thank you again for this video. Another reason NOT to go to VS2022.