When creating a SQL Server 2005 Service Broker m

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

(Continued from previous question...)

When creating a SQL Server 2005 Service Broker message type, what does the EMPTY validation option mean?

Answer: The the message body field must be null.

Explanation: The validation determines how Service Broker will validate the message body for those messages created using this type. EMPTY signifies that the message body must be NULL.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2000, how can you send an alert without sending a message to the client?
• What type of connectivity does the readpipe/makepipe utility test?
• What port do you need to open on your server firewall to enable named pipes connections?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• Can you re-associate the application with the same SSNS instance?
• In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
• The Service Broker operates on messages in which fashion?
• What does the DUMP command do?
• More...