Tuesday, October 03, 2006 - Posts

Service Broker - Enabling Service Broker requires exclusive database access

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Enabling Service Broker requires exclusive database access
The new RSS feed is here

If your trying to enable service broker and it is just hanging then you must have other connections accessing your database.

The enabling of service broker requires a database update lock, this is only possible if there are no other connections in the database. This is because a connection to database will place a shared lock on the database top make sure no one drops it. However this shared lock will block the update lock required to enable service broker.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Enabling Service Broker requires exclusive database access

Service Broker - Dont forget your semi colons

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Dont forget your semi colons
The new RSS feed is here

If you don't know semi colons have been made mandatory in some areas of SQL 2005 and it is likely that it will be required for many more going forward.

Of all the areas I've touched in SQL 2005 Service Broker is the most sensitive to the use of semi colons.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Dont forget your semi colons