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 are different types of replication in sql server?

572


What is attribute hierarchy? : sql server analysis services, ssas

521


What are the differences between triggers and stored procedures?

535


What are the dmvs? : sql server database administration

600


What are the 10 characteristics of data quality?

531






What stored by the model? : sql server database administration

546


What is the current pricing model of SQL Azure?

90


What are the different types of columns types constraints in the sql server?

527


What are locks in sql?

541


How raid can influence database performance?

576


Can sql server be linked with other servers like oracle?

525


whats the maximum size of view state??

1724


What are cascading parameters in ssrs reports?

176


What do you understand by a stored procedure?

604


what is nonclustered index

546