troubleshooting Question

Debugging Sql Stored Procedures

Avatar of Merlin-Eng
Merlin-EngFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerMicrosoft Visual Studio
2 Comments1 Solution100 ViewsLast Modified:
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
Éric Moreau
Senior .Net Consultant
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros