Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 'Open' not showing when debugging SP

Author  Topic 

absavino
Starting Member

2 Posts

Posted - 2008-07-22 : 10:39:14
I am using VS2005 to debug SP's. When I right click some of the SPs, the 'Open' option does not appear. All the other options appear such as 'Add New Stored Procedures, 'Execute, 'Step Into Stored Procedure', etc.

Does anyone know why the 'Open' option is not shown and how to fix it if possible?

Thank you.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-07-22 : 10:43:12
quote:
Originally posted by absavino

I am using VS2005 to debug SP's. When I right click some of the SPs, the 'Open' option does not appear. All the other options appear such as 'Add New Stored Procedures, 'Execute, 'Step Into Stored Procedure', etc.

Does anyone know why the 'Open' option is not shown and how to fix it if possible?

Thank you.


What do you want to do with open option?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

absavino
Starting Member

2 Posts

Posted - 2008-07-22 : 10:54:53
In the SP's where the 'Open' appears, I select it and the SP code appears. I then set my breakpoints.

I have tried opening the SP outside of the Server Explorer debugger and setting up the breakpoints but when I go back to Server Explorer and right click the SP and select 'Step Into Stored Procedure', the breakpoints are not catching.
Go to Top of Page
   

- Advertisement -