-- Set user as db owner --
USE Tango
GO
SP_DROPUSER Developer
GO
SP_CHANGEDBOWNER Developer


-- Maybe this one also ? --
ALTER AUTHORIZATION ON DATABASE::Tango TO Developer;


-- Get state of broker service on each database --
SELECT NAME, IS_BROKER_ENABLED FROM SYS.DATABASES


-- Enable broker service --
ALTER DATABASE Tango SET ENABLE_BROKER;