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