How do you debug the stored procedure?

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

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