Clients ask me questions, I try my best to help if I know the answer. Recently I was asked if I know the how-to List Service Broker Queue Count.
SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It
In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.
SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage
I have mentioned several times on this blog that the best part of blogging is the questions I receive from readers. They are often very interesting. The questions from readers give me a good idea what other readers might be thinking as well. After reading my earlier article Simple Example…
Read MoreSQL SERVER – Introduction to Service Broker and Sample Script
Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered…
Read More
SQL SERVER – Change the Port of Service Broker Configuration
Just two days ago, I wrote a small note about SQL SERVER – Introduction to Service Broker.
SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.
If you face following error the solution of this is very simple. Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process. Above error comes up with Service Broker. Service Broker is used to send Database Emails. Read more about SQL…
Read More
SQL SERVER – Introduction to Service Broker
Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails. You can read about SQL SERVER – Difference Between Database Mail and SQLMail here. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message.