Debugging T-Sql code using Visual Studio 2019. Error message: frame not in module
1
vote
1
answer
797
views
DBAs,
Has anyone had success using **Visual Studio 2019** for debugging T-SQL code, the way **SSMS** allows **Step-into** & **Step-over**?
When I hit debug (**Alt-F5**), gives me this error, after making some progress. Looks like once it hits the section of the code that calls another procedure, it gives this error.
Frame not in module.
The current stack frame was not found in a loaded module. Source cannot be shown for this location.
**Example:**
1 ..
2 ..
3 SELECT 1 FROM sys.objects
4 SELECT dbo.SomeFunction(1)
5 UPDATE TABLE SET X = 1 ....
6
It runs well, until line 3, once it hits line 4, where it is calling a different function, it throws the aboe error. In SSMS, that line just opens a new window with code for the function and show debugging progress for each **F11** step-into -- but not in Visual Studio 2019 (Version 16.7.1)
Thanks
Asked by ToC
(727 rep)
Aug 19, 2020, 01:21 AM
Last activity: Apr 28, 2025, 12:55 PM
Last activity: Apr 28, 2025, 12:55 PM