What does SEND do in SQL Server 2005?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does SEND do in SQL Server 2005?

Answer
Sends a service broker message using a conversation.

Explanation
SEND is used to send a message on an existing conversation in the Service Broker architecture.

(Continued on next question...)

Other Job Interview Questions

• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• How can you determine which Service Broker ports are being used on your server?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• Which collation is used for Service Broker messages sent between the instances?
• What does REVERT do in SQL Server 2005?
• Which of these options cannot be set in the SQL Server 2005 Integration Services Bulk Insert task?
• What result would you expect from this statement? Select * from dbo .MyTable
• A certificate is which type of security mechanism?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• What result would you expect from this statement? Select * from dbo .MyTable
• More...