SQL Collation and Service Broker

We have seen a lot of questions in our support queue on errors been received when enabling the SQL Service Broker or changing the SQL collation of the database. Unfortunately, this error occurs due to the database not been in exclusive mode ( no other transactions are been executed when making the changes). So, in order to set your database exclusive mode, you will need to log into your dasp assigned database using EM or SSMS and issue the following command:

Alter Database [database_name] SET Single_user with rollback immediate

-- allows one user at a time to connect to the database

Next, Change the collation of the database or enable the Service Broker Service

--- enable Service broker
Alter Database [database_name] Set enable_broker

-- change collation
Alter Database [database_name] Collate collation_name

Then, Change the database back to multi user access:

Alter Database [database_name] SET Multi_user


junior

DiscountASP.NET

www.DiscountASP.NET