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:
Post a Comment