TSQL - Service Broker error when sending message to the queue

Post date: Jan 17, 2012 9:43:45 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.-- Fixalter authorization on database ::CustomerDB to sa