Category: DataBase

Contents Introduction Queues Dialogs Conversation Groups Activation Why Use Asynchronous, Queued Messaging? Why Use Transactional Messaging? How Service Broker Solves the Hard Problems in Messaging Message Ordering Coordination Multithreading Receiver Management Why Build Messaging into the Database? Conversation Group Locking Remote Transactional Receive Handling Common Administration Direct Sends to Receive Queue Common Language Support Single-Connection Execution Capability Enhanced Security Transmission Queue Visibility Across Databases Conclusion Introduction With Service Broker, a feature in Microsoft SQL Server 2005, internal or external processes can send and receive guaranteed, asynchronous messages by using extensions to Transact-SQL Data Manipulation Language (DML). Messages can be sent […]

Scenario: You backup & restore (or) create a copy of a SQL DB enabled with SQL Service broker under same SQL server instance. Then run ‘ALTER DATABASE SET ENABLE_BROKER’,  you’ll receive the error as given below:   Msg 9772, Level 16, State 1, Line 1 The Service Broker in database "<DBName>" cannot be enabled because there is already an enabled Service Broker with the same ID. Msg 5069, Level 16, State 1, Line 1 ALTER DATABASE statement failed.   Upon checking is_broker_enabled status in sys.databases for the reported DB, you’ll see the results for is_broker_enabled as zero.   Query: SELECT […]

[Window Title] Program Compatibility Assistant [Main Instruction] This program has known compatibility issues [Expanded Information] After SQL Server Setup completes, you must apply SQL Server 2008 Service Pack 1 (SP1) or a later service pack before you run SQL Server 2008 on this version of Windows. [^] Hide details [ ] Don’t show this message again [Check for solutions online] [Run program] [Cancel]           Installing SQL Server 2008 Service Pack 1 on Windows 7   TITLE: SQL Server Setup failure. —————————— SQL Server Setup has encountered the following error: Invoke or BeginInvoke cannot be called on […]