blob: d46f10bd73909e3f250f2982639ee4d3de0e7709 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- 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;
|
