Answer Posted / ram&saran

It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1

What new changes are being made in SQL Server?

1170

---

What does <> symbol mean?

958

---

What are the kinds of subquery?

1004

---

What is tablix?

162

---

How to use clusters?

933

---

Explain the phases a transaction has to undergo?

1051

---

List the types of recovery model available in sql server?

921

---

Explain atomicity?

1034

---

What is a hint?

985

---

Differentiate between ms sql server reporting services vs crystal reports?

893

---

Will count(column) include columns with null values in its count?

1082

---

Write a SQL queries on Self Join and Inner Join.

1034

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1247

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

997

---

How to sort the query output with order by clauses in ms sql server?

1025

---