When you create a new Message Type in the SQL Se

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

(Continued from previous question...)

When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?

Answer: The owner of the message type.

Explanation: This parameter determines the owner of the message type. This defaults to the current user.

(Continued on next question...)

Other Job Interview Questions

• Which of the following services is instance-aware?
• In SQL Server 2005, what is the maximum size of an index key?
• This administrator will own the jobs. Which role should you assign?
• The Service Broker operates on messages in which fashion?
• What does this return?
• In SQL Server 2005, if you want the keys securing your data to expire over time, what type of key encryption would you choose?
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• Which of the following services is instance-aware?
• No column permissions are assigned. What should you do?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• More...