[Webinar] Streamline your web hosting managementRegister Today


Debug SQL 2008 "Stored Procedure using the Management Studio?

Posted on 2010-03-29
Medium Priority
Last Modified: 2013-12-12
I need to debug sevaral stored procedures that are on a linked server.  I see there is a way to do this using Visual Studio.

IThe Management Studio has a Debug menu, implying that debugging can be done.  If so, how do you get the stored procedure in a window to debug.  With Visual Studio, you ger a "step into"  option when you right click on a stored procedure name.  I don't see this in Management Studio.  

How do I do this?

Question by:mfedenia
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 248 total points
ID: 29049316
here's an example on how to Debug a Stored Procedure in SSMS:


Accepted Solution

ProjectChampion earned 252 total points
ID: 29097594
You can debug in Management Studio for SQL Server 2008: go to view|Tollbars and select "debug"
You can also do more sophisticated debugging in BIDS (Business Intelligence Development Studio) which is in fact the same as Visual Studio for SQL Server developers which you can download from Microsoft Download Centre.

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
Virtualization software lets you run different versions of Windows, Ubuntu Linux and other versions of Linux all at the same time, rather than running each one directly from your computer's hard drive.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question