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.