Configuring SQL Server Service Broker

Service Broker must be enabled in Microsoft® SQL Server for databases created when new TextMap SQL cases are created or registered in the CaseMap Admin Console. Enabling Service Broker ensures indexing success when transcripts are imported into a SQL case file. If Service Broker is disabled, indexing and re-indexing will not occur during import or case creation.

When new TextMap SQL cases are created, the new case will have Service Broker enabled. However, if a database administrator restores a SQL database, the restored SQL database will have Server Broker disabled. After a SQL database is restored from a backup, database administrators need to enable Service Broker for the database.

 

hmtoggle_plus1To check the status of Service Broker

SELECT is_broker_enabled FROM sys.databases WHERE name = 'Database name'

A value of 0 indicates it is off, 1 is on.
hmtoggle_plus1To enable Service Broker

Alter Database [DB_NAME] Set ENABLE_BROKER

 

related_topics_buttonRelated Topics

 

 

Need additional help? Email the CaseMap Support team at: casemap.support@lexisnexis.com, or contact a support representative at 1-800-833-3346 (option 3). The CaseMap Support team is available between the hours of 9:00 a.m. to 7:00 p.m. Eastern Time, Monday - Friday.

© 2018 LexisNexis. All rights reserved.