Enabling Service Broker
The following T-Sql enables or disabled service broker on SqlServer 2005. The Service Broker is required by .net for SqlCacheDependency support
-- Enable Service Broker:
ALTER DATABASE [Database Name] SET ENABLE_BROKER;
-- Disable Service Broker:
ALTER DATABASE [Database Name] SET DISABLE_BROKER;
Is Service Broker enabled?
To determine whether or not Service Broker is enabled for a particular database, execute the following T-SQL
SELECT is_broker_enabled FROM sys.databases WHERE name = 'Database name';
-- Where 'Database name' is the name of the database you want to query.
is_broker_enabled will be 1 if Service Broker is enabled for the given database, otherwise it'll be 0.
| Author |
: Paul Hayman |
| Published |
: Tuesday, 01 August, 2006 |
Paul is the COO of kwiboo ltd consultant and has more than a decade of IT consultancy experience. He has consulted for a number of blue chip companies and has been exposed to the folowing sectors: Utilities, Telecommunications, Insurance, Media, Investment Banking, Leisure, Legal, CRM, Pharmaceuticals, Interactive Gaming, Mobile Communications, Online Services.
Paul is the COO and co-founder of kwiboo (http://www.kwiboo.com/) and is also the creator of GeekZilla.