#StackBounty: #sql-server #t-sql #sql-server-2016 #visual-studio-2019 #debug Debugging T-Sql code using Visual Studio 2019. Error messa…

Bounty: 50

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


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.