You want to disable the receipt of messages in o

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

(Continued from previous question...)

You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?

Answer
ALTER DATABASE Sales SET DISABLE_BROKER
Explanation
To disable the receipt of messages, you can disable the Service Broker by disabling it with the ALTER DATABASE command. The SET command is "DISABLE_BROKER".

(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 does the max full-text crawl range option do?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• On which port does the dedicated administrator connection listen in SQL Server 2005?
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• How many plans must you setup?
• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• When declaring an XML document, which type allows text nodes at the top level?
• What does this code return? select 6 | 7 Figure it out without running it.
• More...