exception occurred while enqueueing a message in the target queue. Error: 15404, State

Question

I am so new to Service Broker. I found a simple example as you can see here:

CREATE DATABASE ServiceBrokerTest
GO
USE ServiceBrokerTest
GO

-- Enable Service Broker
ALTER DATABASE ServiceBrokerTest SET ENABLE_BROKER
GO

-- Create Message Type
CREATE MESSAGE TYPE SBMessage
VALIDATION = NONE
GO

-- Create Contract
CREATE CONTRACT SBContract
(SBMessage SENT BY INITIATOR)
GO

-- Create Send Queue
CREATE QUEUE SBSendQueue
GO

-- Create Receive Queue
CREATE QUEUE SBReceiveQueue
GO

-- Create Send Service on Send Queue
CREATE SERVICE SBSendService
ON QUEUE SBSendQueue (SBContract)
GO

-- Create Receive Service on Receive Queue
CREATE SERVICE SBReceiveService
ON QUEUE SBReceiveQueue (SBContract)
GO

-- Begin Dialog using service on contract
DECLARE @SBDialog uniqueidentifier
DECLARE @Message NVARCHAR(128)
BEGIN DIALOG CONVERSATION @SBDialog
FROM SERVICE SBSendService
TO SERVICE 'SBReceiveService'
ON CONTRACT SBContract
WITH ENCRYPTION = OFF

-- Send messages on Dialog
SET @Message = N'Very First Message';
SEND ON CONVERSATION @SBDialog
MESSAGE TYPE SBMessage (@Message)

SET @Message = N'Second Message';
SEND ON CONVERSATION @SBDialog
MESSAGE TYPE SBMessage (@Message)

SET @Message = N'Third Message';
SEND ON CONVERSATION @SBDialog
MESSAGE TYPE SBMessage (@Message)
GO

-- View messages from Receive Queue
SELECT CONVERT(NVARCHAR(MAX), message_body) AS Message
FROM SBReceiveQueue
GO

-- Receive messages from Receive Queue
RECEIVE TOP(1) CONVERT(NVARCHAR(MAX), message_body) AS Message
FROM SBReceiveQueue
GO

-- Receive messages from Receive Queue
RECEIVE CONVERT(NVARCHAR(MAX), message_body) AS Message
FROM SBReceiveQueue
GO

This link example link but when I run the query it returns zero records - why?

Answer 1

I finally execute this code and it works

sp_changedbowner 'sa'