Wednesday, January 6, 2016

Assembly Trust Issues and Set Trustworthy ON in SQL Server 2008

Simply use below query:

USE <dbname>;
EXEC sp_configure 'clr enabled' ,1
GO

RECONFIGURE 
GO 
EXEC sp_configure 'clr enabled'   -- make sure it took 
GO 

USE <dbname>
GO 

EXEC sp_changedbowner 'sa' 
USE <dbname>
GO 

ALTER DATABASE <dbname> SET TRUSTWORTHY ON;

No comments:

Post a Comment