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

917

---

Describe triggers features and limitations?

1051

---

What is ms sql server service broker?

1041

---

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

980

---

What are the components of sql server service broker?

1060

---

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

986

---

Do you know how to implement service broker?

967

---

Explain what is the main purpose of having conversation group?

986

---

Explain sql server service broker?

1026

---

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

1050

---

How to encrypt data between dialogs?

1167

---

Explain isolation levels that sql server supports?

1082

---

Explain what is lock escalation and what is its purpose?

981

---

Explain different types of lock modes in sql server 2000?

982

---

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

995

---