Answer Posted / sivakumar
Steps for debugging stored procedure is given below
1.Open the Microsoft visual Studio
2.Select Server Explorer
3.Add Server
4.Select Database Where Procedure is located
5.Select Procedure for debug
6.Right click and select Step into stored procedure
7.Pass Parameter to that procedure
8.Then Do debug.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
what is create database syntax? : Sql server database administration
How do I find the size of a sql server database?
Explain sql server authentication modes?
Explain what is lock escalation?
What are the properties of sub-query?
What is a result set object returned by mssql_query()?
How to get @@error and @@rowcount at the same time?
How to delete an existing database user?
How to define and use table alias names in ms sql server?
Explain what you mean by 3 tier architecture.
What is sub-query in sql server?
Can we use trigger new in before insert?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is a group function explain with an example?
What are sub reports and how to create them?
