• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 45
  • Last Modified:

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.
1 Solution
Éric MoreauSenior .Net ConsultantCommented:
Yes you can use Visual Studio but if your app is in Access that won't help you much. It is normally used to debug when a .net app is being debugged and you step into the SP just like your Vb/C# code. It won't be helpful if you are using Access!

That being said, you can also debug SPs using SSMS which is much easier to setup.
Merlin-EngWorks ManagerAuthor Commented:
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now