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 do you mean by data manipulation language?

1019

---

Difference between DELETE and TRUNCATE?

1050

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1073

---

What are the hotfixes and patches in sql server?

1017

---

How you can get a list of all the table constraints in a database? : Sql server administration

1029

---

How does index makes search faster?

979

---

What is an inner join?

983

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1078

---

How to use subqueries with the exists operators in ms sql server?

1119

---

What is difference between views and stored procedures?

991

---

How to set database to be read_only in ms sql server?

1011

---

What is bulkcopy in sql?

944

---

Explain SSRS Architecture?

195

---

What is the use of set nocount on/off statement?

1097

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

985

---