index > Visual Studio Debugger > Debugging Stored Proc using Visual Studio 2005

Debugging Stored Proc using Visual Studio 2005

I installed Visual Studio 2005 Professional Edition to be able to debug stored procs in my sql server 2005 db using the 'Step into Stored Procedure ' option.

However, when I right click on the stored proc I only have the following options: Copy, Refresh, Properties.

The options that are missing are:

Add New Stored Procedure
Open
Execute
Step into stored procedure
Delete

How do I get the above options that are missing ?

AssetCo Wednesday, October 14, 2009 11:56 AM

Hello,

Please run Visual Studio with /resetSkipPkgs switch.

Best regards,

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback, please tell us.
Welcome to the All-In-One Code Framework!

Roahn Luo Thursday, October 15, 2009 3:15 AM

Hi Roahn,

I have removed Visual Studio 2005 using Control Panel/Add or remove Programs

I have re-installed using the switch above as you suggested i.e I open command window and run " X:\setup.exe" resetSkipPkgs

During the installation I now get the following message while it is installing component Microsoft Visual Studio 2005:

Error 1311: Source file not found: x:\_15780_RTL_x86_enu_NETCF_v2.0.cab. Verify that the file exxists and that you can access it.

The file does not exist on the CD s0 I have to cancel the setup.exe.

Any suggestions please woul be appreciated

AssetCo Friday, October 16, 2009 12:23 PM

Hi Roahn,

Sorry, the missing file was on CD2 so when i removed CD1 and inserted CD2 the installation carried on.

After the installation is complete I will confirm/not whether I have the option to 'Step into Stored Procedure' to be able to debug.

AssetCo Friday, October 16, 2009 1:22 PM

Hi Roahn,

The installation of Visual Studio 2005 Professional Edition is complete but I still do not have the option to be able to 'Step into stored procedure' to enable me to debug ?

Any suggestions would be appreciated

AssetCo Friday, October 16, 2009 1:38 PM

Hello AssetCo,

Thanks for your feedback!
The switch /resetSkipPkgsruns with devenv.exe in Visual Studio Command Prompt, are there any other issues during installation? SQL/CLR debugging needs Professional editionor higer, do you have another copy of Visual Studio? I recommend you try using Visual Studio 2008Team Systemedition to see if that feature is there.

By the way, issues for Visual Studio Setup and Installation could be posted at:
http://social.msdn.microsoft.com/Forums/en/vssetup/threads
I believe you'll get more help there.

Best regards,

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback, please tell us.
Welcome to the All-In-One Code Framework!

Edited byRoahn LuoMSFT, Moderator8 hours 34 minutes agoVS setup forum.

Roahn Luo 8 hours 36 minutes ago

You can use google to search for other answers

Custom Search

More Threads

• More svchost problems

• OleDbconnection

• Windbg result,..What is Error

• Help! Can't set breakpoints since installing VS 2008 SP1

• Unable to open/debug a remote site from VS2005

• debugging with power user privilege

• DVDSample Protection Error

• How to debug VC++ COM objects on Windows Server 2008 with Visual Studio 2008

• VS2005 crashes immediately after debugging starts (when a browser gets lauched)

• How to debug SQL Server 2005 stored procedure?