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

877

---

Describe triggers features and limitations?

989

---

What is ms sql server service broker?

992

---

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

936

---

What are the components of sql server service broker?

1016

---

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

941

---

Do you know how to implement service broker?

928

---

Explain what is the main purpose of having conversation group?

940

---

Explain sql server service broker?

977

---

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

993

---

How to encrypt data between dialogs?

1107

---

Explain isolation levels that sql server supports?

1039

---

Explain what is lock escalation and what is its purpose?

932

---

Explain different types of lock modes in sql server 2000?

931

---

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

949

---