24 September, 2010 Roel van Lisdonk 0 Comments 1 category

If you are using SqlCacheDependency in you’re ASP .NET website, the database must have SQL Server Broker enabled. To enable SQL Server Broker on a SQL Server 2005 database use:

USE master
GO

ALTER DATABASE Dagstaten SET ENABLE_BROKER  WITH ROLLBACK IMMEDIATE 
GO

The set enable_broker requires an exclusive lock on the database, so use “with rollback immediate”.

Tags:
Category: Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts