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

How to drop existing views from a database in ms sql server?

1096

---

how to create “alternate row colour”?

146

---

What is SQL Azure Federations?

112

---

What is nonclustered index on computed columns?

948

---

What is the rdl file?

138

---

Do you know the policy based administration feature of sql server 2008?

947

---

What is a bit datatype?

978

---

How to loop through the result set with @@fetch_status?

1333

---

What number aggregate functions are accessible there in sql?

1066

---

Do you know what is difference between stored procedure and user defined function?

1089

---

How to insert new line characters into strings?

983

---

What are the steps you can take to avoid “deadlocks”?

970

---

Can we deploy SSRS reports on our personal website?

168

---

Explain what is the main purpose of having conversation group?

926

---

How to drop an existing stored procedure in ms sql server?

1024

---