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 is difference between global temporary tables and local temporary tables?

660

---

Distinguish between commit and rollback?

549

---

How do I find information about the install locations for the various instances running on a computer?

554

---

How to find the login name linked to a given user name?

533

---

Create and insert into temp table in sql server?

584

---

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1002

---

Write a SQL command to insert and update only a particular field?

630

---

How to make conditional sum in ssrs?

132

---

How to Insert multiple rows with a single insert statement?

549

---

What is blocking?

569

---

Why SQL Agent is used?

600

---

what's the information that can be stored inside a bit column? : Sql server database administration

527

---

What is the difference between migration and upgradation in sql server?

606

---

Explain the architecture of ms sql reporting service?

534

---

What is query parameter in ssrs?

118

---