Debuging sql server stored procedure

  • how can I Execute Step by step of Sql server Stored Procedures?

    via Query Analizer

    or when Stored procedure call from An Application(Visual Basic)

    by regard

    hashemi

    hashemi-te@esfahansteel.com

  • If you are using SQL Server 2008 then you can directly debug it using green triangle button available in toolbar.

    In Query Analyzer window, write the line - EXECUTE <ProcName> <Param1,Param2.....> and click on that button. It will bring focus on this line then keep pressing F11 or use toolbar

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply