[Last Call] Learn how to a build a cloud-first strategyRegister Now


Visual STudio 2008 - Debugging Store Proceedures.

Posted on 2011-10-12
Medium Priority
Last Modified: 2012-05-12
I need to set up my Visual Studio so that I can debug stored proc.  Anyone know the process for that?  I also have SQL Management STudio 2008 R2

Question by:TimSweet220
LVL 29

Expert Comment

ID: 36961861
I *think* it will be better to get your stored procedures working using management studio before invoking it from your .net app.
LVL 70

Accepted Solution

Éric Moreau earned 2000 total points
ID: 36961905
have you tried to create a "data connections" in the "server explorer", then navigate to your SP and select "step into stored procedure" ?

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

830 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