What are the default system databases in sql server 2000?

0 Answers  

---

What types of replication are supported in sql server?

0 Answers  

---

What is snapshot replication?

0 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

What is rank function?

0 Answers  

---

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

What is a trigger and its types?

0 Answers  

---

How to convert character strings into numeric values?

0 Answers  

---

What is a trigger what are the advantages of trigger?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---

What is a with(nolock)?

0 Answers  

---