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 the difference between value type and reference type?
What are distributed partitioned views?
What is the primary use of the model database?
If no size is defined while creating the database, what size will the database have?
What is the importance of three tier architecture?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is the security model used in sql server 2005?
Write query to return all rows sql?
Tell me what is de-normalization and what are some of the examples of it?
Comment,Datatypes are unlimited
How to provide column names in insert statements in ms sql server?
List all the types of user-defined functions?
What are data resources?
What is the index requirement in SQL Azure?
How to end a stored procedure properly in ms sql server?
