Determine how to use the inserted and deleted pseudo tables?
Explain trigger classes i.e. Instead of and after trigger?
Describe triggers features and limitations?
What is ms sql server service broker?
Please explain what is “asynchronous” communication in sql server service broker?
What are the components of sql server service broker?
Tell me what are the essential components of sql server service broker?
Do you know how to implement service broker?
Explain what is the main purpose of having conversation group?
Explain sql server service broker?
Tell me what do we need queues in sql service broker?
How to encrypt data between dialogs?
Explain isolation levels that sql server supports?
Explain what is lock escalation and what is its purpose?
Explain different types of lock modes in sql server 2000?