Just Code‎ > ‎

TSQL - Service Broker error when sending message to the queue

posted Jan 17, 2012, 1:43 AM by Peter Henell   [ updated Jan 17, 2012, 1:44 AM ]
BOL about ALTER AUTHORIZATION:  http://msdn.microsoft.com/en-us/library/ms187359.aspx 
--An exception occurred while enqueueing a message in the target queue. Error: 33009, State: 2. 
--The database owner SID recorded in the master database differs from the database owner SID recorded in database 'CustomerDB'. 
--You should correct this situation by resetting the owner of database 'CustomerDB' using the ALTER AUTHORIZATION statement.

-- Fix
alter authorization on database ::CustomerDB to sa