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

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

What is sql server profiler?

0 Answers  

---

How do I trace a query in sql server?

0 Answers  

---

How to check status of stored procedure in sql server?

0 Answers  

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

---

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

Can I work with several databases simultaneously? : sql server management studio

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

Name the different type of indexes in sql?

0 Answers  

---

What are different types of data sources?

0 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

Mention a few common trace flags used with sql server?

0 Answers  

---