How do you debug the stored procedure?

 Posted by Rajnilari2015 on 12/19/2015 | Category: Sql Server Interview questions | Views: 466 | Points: 40
Answer:

Old is Gold
--------------

By using the Print() command of TSQL

Since Sql Server 2008
------------------------

From SSMS,we can start the debugger by either clicking the Debug button on the Query toolbar or by clicking Start Debugging on the Debug menu or pressing ALT+F5.

From Visual Studio 2010
---------------------------

Step 1: Open Server Explorer -> Server nodes-> SQL Server machine name -> SQL Servers node -> SQL Server instance -> Your database node -> stored procedures node.

Step 2: Right-click YOUR stored procedure and then click Step Into Stored Procedure.

Step 3: Press F11 to step through the stored procedure.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response