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 keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Can a table be moved to different filegroup?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is checkpoint process in the sql server?
What are data regions?
explain different types of cursors? : Sql server database administration
What are the types of processing and explain each? : sql server analysis services, ssas
What is the partitioning method?
What is nonclustered index with included columns ?
What does man by sql wildcard characters in sql server?
What is the need for indexing?
What is normalization of database?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
How will you go about resolving deadlocks?
Explain DBCC?
