Can we use pragma autonomous_transaction in trigger?

0 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

What is the size of transaction log file?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---

Explain the stored procedure?

0 Answers  

---

---

what do you understand by change data capture?

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

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

0 Answers  

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---

What is the difference between substr and charindex in the sql server?

0 Answers  

---