Saturday, August 22, 2009

Enable SQL Broker

The proper syntax for the alter database statement is:

ALTER DATABASE OperationsManager SET ENABLE_BROKER WITH ROLLBACK AFTER 5

The options after the "WITH" also include NO_WAIT & ROLLBACK IMMEDIATE

Providing for the New Data Base
ALTER DATABASE DatbaseName SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

No comments: