Debug SP

• Sql Junkie-204042

  Hall of Fame

  Points: 3874

  More actions

  May 18, 2007 at 8:15 am

  #178995

  I have installed SQL 2005 Std. Edition and when I right-click on the SP from "SQL Server Business Intelligence Development Studio" I do not see the option "Step into Stored procedure".

  Do I need to install something else or do I need to 'turn on' a feature?

  Thanks.

   

• Grant Fritchey

  SSC Guru

  Points: 398898

  More actions

  May 18, 2007 at 8:44 am

  #707478

  I believe that debugging is only available through Visual Studio.

  http://msdn2.microsoft.com/en-us/library/ms165034(VS.80).aspx

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning