Welcome to SqlAdvice Sign in | Join | Help

Enable CLR and Unsafe Assemblies SQL Server 2005

Since I can never remember this off the top of my head I figured I would post on my blog. 

To enable the use of CLR on SQL Server run the following....

EXEC sp_configure 'show advanced options' , '1'; go reconfigure; go EXEC sp_configure 'clr enabled' , '1' go reconfigure; -- Turn advanced options back off EXEC sp_configure 'show advanced options' , '0'; go

To allow unsafe assemblies to run execute the following code against the database that is hosting the unsafe assembly.

alter database MyDatabase set trustworthy on
Sponsor
Published Wednesday, July 18, 2007 1:59 PM by gstark

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
required 
(required) 
Enter the code you see below