CaseMap Server

Configuring SQL Server Service Broker

Configuring SQL Server Service Broker

 Previous topic Next topic No directory for this topic Expand/collapse all hidden text  

Configuring SQL Server Service Broker

 Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

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 877.301.0344. International user? For CaseMap, please call 904.373.2160. The CaseMap Support team is available between the hours of 9:00 a.m. to 9:00 p.m. ET, Monday - Friday.