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 will happen if a column containing char type data is changed to the nchar data type?

700

---

What is the datatype of rowid?

587

---

What is identity?

662

---

How to include date and time values in sql statements?

704

---

What are the new scripting capabilities of ssms? : sql server management studio

636

---

---

Explain the rules for designing files and file groups in sql server?

635

---

How many types of attribute relationships are there? : sql server analysis services, ssas

668

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

663

---

Which table keeps information about stored procedures?

613

---

Explain what is the difference between union and union all?

649

---

What is a non-clustered index?

642

---

Define Wed Edition in SQL Azure?

90

---

can any body tell me how to know the password of current user in sql server

1668

---

How can you tell if a database object is invalid?

695

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

606

---