Home
Manage Your Code
Snippet: Enable CLR for SQL Server (SQL)
Title: Enable CLR for SQL Server Language: SQL
Description: SQL to turn on the CLR support for SQL Server 2005 Views: 239
Author: Kevin Isom Date Added: 4/14/2008
Copy Code  
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

--ALTER DATABASE [dbname] SET TRUSTWORTHY ON