Explain trigger classes i.e. Instead of and after trigger?

825

---

Describe triggers features and limitations?

926

---

What is ms sql server service broker?

932

---

Please explain what is “asynchronous” communication in sql server service broker?

879

---

What are the components of sql server service broker?

945

---

Tell me what are the essential components of sql server service broker?

885

---

Do you know how to implement service broker?

886

---

Explain what is the main purpose of having conversation group?

880

---

Explain sql server service broker?

925

---

Tell me what do we need queues in sql service broker?

926

---

How to encrypt data between dialogs?

1031

---

Explain isolation levels that sql server supports?

986

---

Explain what is lock escalation and what is its purpose?

874

---

Explain different types of lock modes in sql server 2000?

879

---

What are the different types of lock modes in sql server 2000?

882

---