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
Do you know what is fill factor and pad index?
Explain what is log shipping?
What is the maximum size of a dimension? : sql server analysis services, ssas
What are the steps to insert a table?
What is 2nf normalization form?
wat wil hapn if we give the both read and deny read permission to user?
Is ssrs support other database except ms sql server?
Do you know the different ddl commands in sql?
What do you mean by cardinality?
What is the definition for sql server 2000?
How can change procedure in sql server?
What is failover clustering overview?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Define inner join? Explain with an example?
Are semicolons required at the end of sql statements in sql server 2005?