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

875

---

Describe triggers features and limitations?

987

---

What is ms sql server service broker?

984

---

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

930

---

What are the components of sql server service broker?

1011

---

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

939

---

Do you know how to implement service broker?

928

---

Explain what is the main purpose of having conversation group?

929

---

Explain sql server service broker?

970

---

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

983

---

How to encrypt data between dialogs?

1098

---

Explain isolation levels that sql server supports?

1032

---

Explain what is lock escalation and what is its purpose?

925

---

Explain different types of lock modes in sql server 2000?

928

---

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

936

---