How to Debug a Stored Procedure?

Answer Posted / ris

Steps for debugging stored procedure is given below
1.Open the object browser
2.right click the procedure that u want to debug
3.from the popup menu select debug option
4.from the displayed window ,give the values for input
parameters
5.click the button debug

Is This Answer Correct ?    12 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does set rowcount do?

691


How to rebuild master databse?

836


Explain Reporting Life Cycle?

102


Suggest a method of joining two tables.

813


How to modify existing triggers using "alter trigger"?

702






How ssrs maintain security?

778


How to update a field in SQL after ALTERING a row?

880


What is the data tier application?

159


What is mean by dml?

734


What is triggers in ms sql server?

804


Difference between Logical Page and Physical Page in SSRS.

412


Which Model uses the SET concept

747


What are data files?

771


What is executereader?

724


What is a data source file?

681