Unable to debug 2005 sprocs within VS 2005

• netmikem

  SSCarpal Tunnel

  Points: 4001

  More actions

  September 29, 2006 at 10:42 am

  #367508

  Hi everybody.

  I can't seem to get the ability to step into a stored procedure using VS 2005. I'm simply trying to debug a stored procedure in a SQL Server 2005 database (residing on another machine).

  I can setup the data connection in VS 2005 without any problems and I can see the SQL Server database and stored procedures. However, when I right click on any stored procedure, there is no option to 'step into' the procedure. I only see options to 'Open' or 'Execute'. All the debug options are disabled.

  I'm connecting as sa.

  My VS 2005 installation shows the following products are installed...

  SQL Server Analysis Services

  SQL Server Integration Services

  SQL Server Reporting Services

  Am I missing a required product perhaps?

  Thanks.

  - Mike

• October 2, 2006 at 8:00 am

  This was removed by the editor as SPAM

• John Nolan

  Mr or Mrs. 500

  Points: 581

  More actions

  November 13, 2006 at 4:33 am

  #671294

  You need to have the Database template which comes with VS 2005 Professional.