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 view the error log for any specific instance? : sql server database administration

984

---

What is 1nf 2nf and 3nf?

844

---

What is page-level compression?

901

---

What is Sqlpaging in SqlServer 2005 ?

1010

---

what are cursors? : Sql server database administration

989

---

Can we add a cpu to sql server?

954

---

Explain powershell included in sql server 2008?

996

---

What are the different types of collation sensitivity in sql server?

1033

---

What is database dimension? : sql server analysis services, ssas

1028

---

What are the different types of sub-queries?

993

---

List some major differences between triggers and stored procedures?

853

---

How do I partition a table in sql server?

981

---

Define right outer join in sql server joins?

976

---

What is the correct order of the logical query processing phases?

871

---

A trigger can reference objects outside the current database? State true or false.

942

---