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
When would you prefer to have a minimum number of indexes?
What is the difference between a local and a global temporary table?
What are the different types of Indexes available in SQL Server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Explain “row_number()” in sql server with an example?
what is denormalization? : Sql server database administration
Define Business Edition in SQL Azure?
Explain something about security and SQL Azure?
How to select all columns of all rows from a table with a select statement in ms sql server?
Explain indexed views and partitioned view with their syntax.
How can you check the version of sql server?
How do I install sql server?
your distribution database is full what will u do
What is the difference between dataadapter and datareader?
What are advantages of ssrs or why we should use ssrs?
