USE Util
EXEC SP_CHANGEDBOWNER 'SA'
ALTER DATABASE Util SET TRUSTWORTHY ON
GO
ALTER DATABASE Util SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
GO
IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'System.DirectoryServices' and is_user_defined = 1)
CREATE ASSEMBLY [System.DirectoryServices] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.DirectoryServices.dll'
WITH PERMISSION_SET = UNSAFE
IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'System.Management' and is_user_defined = 1)
CREATE ASSEMBLY [System.Management] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Management.dll'
WITH PERMISSION_SET = UNSAFE
IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'Microsoft.Data.Schema.ScriptDom' and is_user_defined = 1)
CREATE ASSEMBLY [Microsoft.Data.Schema.ScriptDom] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\Microsoft.Data.Schema.ScriptDom.dll'
WITH PERMISSION_SET = UNSAFE
IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'Microsoft.Data.Schema.ScriptDom.Sql' and is_user_defined = 1)
CREATE ASSEMBLY [Microsoft.Data.Schema.ScriptDom.Sql] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\Microsoft.Data.Schema.ScriptDom.Sql.dll'
WITH PERMISSION_SET = UNSAFE
GO
/*
ALTER ASSEMBLY [System.DirectoryServices] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.DirectoryServices.dll'
WITH PERMISSION_SET = UNSAFE
ALTER ASSEMBLY [System.Management] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Management.dll'
WITH PERMISSION_SET = UNSAFE
GO
ALTER ASSEMBLY [Microsoft.Data.Schema.ScriptDom] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\Microsoft.Data.Schema.ScriptDom.dll'
WITH PERMISSION_SET = UNSAFE
GO
ALTER ASSEMBLY [Microsoft.Data.Schema.ScriptDom.Sql] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\Microsoft.Data.Schema.ScriptDom.Sql.dll'
WITH PERMISSION_SET = UNSAFE
GO
*/