Dedicated administrator connections are not supported message in SQL Server

SET ENABLE_BROKER never completes in SQL Server

How to enable, disable and check if Service Broker is enabled on a database

ALTER DATABASE [Database_name] SET ENABLE_BROKER;

If the SET ENABLE_BROKER hangs and never completes read the previous article:

SET ENABLE_BROKER never completes in SQL Server

If you get an error when trying to enable Service Broker read the related blog post:

SQL Server Service Broker cannot be enabled error

ALTER DATABASE [Database_name] SET DISABLE_BROKER;

To check if Service Broker is enabled on a SQL Server database:

SELECT is_broker_enabled FROM sys.databases WHERE name = Database_name;

If the result is 1, the Service Broker is enabled.

SET ENABLE_BROKER never completes in SQL Server

SQL Server Service Broker cannot be enabled error

July 26th, 2012 Tags:Service BrokerSQL ServerCategory:SQL Server

How to List all Mirrored SQL Server Databases

How to specify a Port Number to Connect to SQL Server Instance

How install SQL Server 32Bit on Windows 64Bit

Find all Tables with and without Identity column in SQL Server Database

Find all Filtered Indexes in SQL Server Database

Find all Indexes that have Included Columns in SQL Server Database

Find all Primary Key Columns from a SQL Server table

How to get Column names of a Table or a View in SQL Server

Find all Tables with Specified Column Name in a SQL Server Database

Find Tables without Clustered Index and with Primary Key in a SQL Server Database

List Tables with Foreign Key Constraint in a SQL Server Database

List all User Tables With and Without Primary Key Constraint in a SQL Server Database

List all User Tables in a SQL Server Database with no Clustered Index

Find Fill Factors for Indexes in a SQL Server Database