Link to home
Start Free TrialLog in
Avatar of Merlin-Eng
Merlin-EngFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Debugging Sql Stored Procedures

I'm an MS Access Developer using SQL Server 2008 as a back end. I use SQL Stored procedures quite a lot, but i'm always slowed down by the fact that you cant step into Stored Procedures in SQL Server Management studio. This makes it quite tedious to debug a stored procedure and get it working.

I read a while back that is possible to use Visual Studio to debug stored procedures. I've installed Visual Studio 2017 community. So can i edit/debug stored procedures now? i can't immediately work out how to do it.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Merlin-Eng

ASKER

Debugging in the SSMS. I feel stupid. I've been using it for years. Never realised you could debug sp's in there. That's sorted me out. Thank you so much.

Ian