Common SQL Server CLR database settings

Common SQL Server CLR database settings

SELECT  'Pre Deployment Changes',name ,
        is_trustworthy_on ,
        SUSER_SNAME(owner_sid) AS [DBOwner]
FROM    sys.databases
WHERE   name = 'databaseName';

USE [master];
GO
ALTER DATABASE databaseName SET READ_WRITE WITH	ROLLBACK IMMEDIATE;
GO
USE databaseName;
GO
EXEC sp_changedbowner 'sa';
GO
USE [master];
GO
ALTER DATABASE databaseName SET READ_ONLY WITH	ROLLBACK IMMEDIATE;
GO
ALTER DATABASE databaseName SET TRUSTWORTHY ON
GO

SELECT  'Post Deployment Changes', name ,
        is_trustworthy_on ,
        SUSER_SNAME(owner_sid) AS [DBOwner]
FROM    sys.databases
WHERE   name = 'databaseName';