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
Can a table be moved to different filegroup?
What is SQL Azure Fabric?
what is the system function to get current user's user id? : Sql server database administration
Define right outer join?
What are the disadvantages of indexes?
What is dbcc?
What is statement level trigger?
What are binary string data types in ms sql server?
What is explicit mode in sql server?
List out the difference between union and union all in sql server?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Explain the commands in sql server?
Explain primary key?
What is the purpose of the master database?
How to see the event list of an existing trigger using sys.trigger_events?
