SQL Server Technologies
"Learning is the key to unlock the door of golden future"
Pages
Home
SQL Scripts
Powershell Scripts
Sunday, 28 June 2015
How to enable, disable and check if Service Broker is enabled on a database?
SELECT name, is_broker_enabled FROM sys.databases
ALTER DATABASE test SET ENABLE_BROKER;
ALTER DATABASE test SET DISABLE_BROKER;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment