Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Debug Store Procedure in Sql Server 2005 Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2007 11:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 27, 2011 9:14 AM
Points: 20, Visits: 18
Hello All,
Greetings.


I have serious problem while dealing with Stored Procedure in Sql server 2005. I knew how to debug the SP in sql server 2000. in Query Analyzer right clicking the SP name and selecting the Debug option. But i don't know about how to debug it in Sql Server 2005. Can anyone please tell me in detail how to do it.
Please tell me urgently.

Thanks in Advance
Abhay
Post #419921
Posted Tuesday, April 8, 2008 6:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 22, 2010 5:29 AM
Points: 1, Visits: 32
Hi, You can using the Visual Studio.

Bye...
Post #481461
Posted Wednesday, April 9, 2008 2:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 27, 2011 9:14 AM
Points: 20, Visits: 18
Thanks for your coments.
can you please tell me how to debug it in Visual studio. As i don't have any idea relating to it. Please guide me.

Thanks in Advance
Abhay
Post #482120
Posted Thursday, April 10, 2008 7:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, January 17, 2012 2:51 AM
Points: 935, Visits: 251
To get started, you might try:

Make a new project in Vis Studio, choose other project types, then database. (Note I am using VS 2005)

Create a database reference when prompted (or right click on database reference in Solution Explorer)

Fill in the dialogue boxes to specify the sql server and database you want to use.

Then look in the Server Explorer, expand Stored Procs container, and pick the stored proc you want. Right click on that and Step Into proc.

That should get you started.

For some reason I suddenly have the paranoid feeling that everyone will now post better replies which need less mouse clicks or whatever! :)
Post #483019
Posted Saturday, April 12, 2008 1:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 27, 2011 9:14 AM
Points: 20, Visits: 18
Well thanks Paul. I have been waiting for this reply since last 2 months. thanks a lot.

Abhay
Post #484047
Posted Tuesday, June 23, 2009 1:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 31, 2013 8:17 AM
Points: 3, Visits: 37
Hi,

I dont see the 'step into' option and I also dont see the database in th e'other projects' when I try to create new project in VS2005. Obviously I am missing stuff. Can you tell what?

Sandeep



Kind Regards,

Sandeep Kataria
Post #740490
Posted Sunday, June 28, 2009 11:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 1, 2009 6:48 AM
Points: 1, Visits: 15
Hi,
Login as Windows Authentication then try for Debug.


Post #743353
Posted Monday, June 29, 2009 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 31, 2013 8:17 AM
Points: 3, Visits: 37
Thanks Kumar but I am logging in with windows authentication...

Sandeep



Kind Regards,

Sandeep Kataria
Post #743614
Posted Wednesday, July 1, 2009 1:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 27, 2011 9:14 AM
Points: 20, Visits: 18
Hi Sandeep,
You can Click on "View" menu and can select "Sever Explorer" option from it. From there you can connect to your Server by giving correct credentials. After that the Server Explorer will appear at the left side of the window.
You can select any "Blank Solution" and can follow the steps. After getting the "Server Explorer" you can expand the "Stored Procedure" option and can select the specific Stored Procedure and right click the mouse and select "Open" option. Which will open your Stored Procedure in Editable window. After that you can select "Debug" menu option and click on "Start Debugging".

Hope this can solve your problem.

Bye
Abhay
Post #745132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse