I have inherited a SQL Server stored procedure that I need to step through, and since debugging is no longer in SSMS I'm trying to use Visual Studio 2019. Here are the steps I'm using. I open Visual Studio and choose continue without code. Then I create a new data connection, right click the db and choose "New Query".
I paste in this
EXEC _healthandwelfare_rev4
@bachnumb = N'TMW20210306',
@prenddate = N'03-06-2021',
@includeunpaidfte = 1,
@fullrecalc = 1
I then set a break point on it, and use the SQL menu to Execute with Debugger. The issue is it just runs the whole thing and never stops to give me the step options. Honestly really stumped here on what I'm missing.
You cannot debug a SP in Visual Studio by the way you are doing.