Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is RMS migrations?
What are triggers in ms sql server?
What is normalization 1nf 2nf 3nf?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Is the order of columns in the set clause important in ms sql server?
What is the difference between inner join and equi join?
How do you delete duplicate rows in sql server?
how to avoid cursors? : Sql server database administration
what is a transaction and what are acid properties? : Sql server database administration
How will you decide the active and passive nodes?
How to fetch the next row from a cursor with a "fetch" statement?
how to trace the traffic hitting a sql server? : Sql server database administration
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
what are the types of indexes? : Sql server database administration
How to execute a stored procedure in ms sql server?
