asked on 11/29/2017

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.

Microsoft SQL Server Microsoft Visual Studio

Last Comment

Merlin-Eng

11/29/2017

ASKER CERTIFIED SOLUTION

Éric Moreau

11/29/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Merlin-Eng

11/29/2017

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

Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K

Questions

Followers

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY