Answer / raj..

There is a limit of 32 on the maximum nested levels on both
SQL Server 2000 and 2005

Answer / naveen

32 nested transaction can possible in sql server

Answer / naveen singh

three type of

(1)Begin
(2)Rollback
(3)commit

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---

What is the SQL?????????????????????????????

5 Answers   CMS,

---

How to provide default values to stored procedure parameters?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

---

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

---

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

Explain different backup plans?

0 Answers  

---

How to store pdf file in sql server?

1 Answers   CarrizalSoft Technologies, College School Exams Tests, TATA,

---

Explain nested trigger in sql?

0 Answers  

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

What are system databases into sql server (2005/2008)?

0 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---