Hey folks – I’ve seen some comments and replies stating that folks cannot use the debugger with SSDT in Visual Studio, so I decided to give it a try to see if there were any issues. Good news, it works! In this post we’ll step through how to use the debugger with SSDT and Visual Studio, and I’ll call out up front that it requires more permissions than you might realize.
To get started, install Visual Studio, and the SQL Server Data Tools – Sql Editor (SSDT) extension if you don’t already have them. If you do not have a license