Debug Stored Procedure

From: Steve (stevea_at_centurion-ms_RemoveThis_.co.uk)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 18:02:11 -0000

Hi all

I want to be able to debug stored procedures. I am following the KB article
HOW TO: Debug Stored Procedures in Visual Studio .NET (316549) and it states
that I need to right-click on the Stored Proc in Server Explorer and select
Step Into Stored Procedure, but I don't have that option. All I have is Run
Stored Procedure.

It also says that I should be able to right-click and select Edit Stored
Procedure to place a breakpoint within it, but again, I do not have this
option.

I have enabled SQL Server Debugging in the project. I am using VS 2003 and
SQL Server 2000.

How am I able to get the menu options that are in the article?

Thank you for any help.

Regards,
Steve.

Relevant Pages
Loading