Search

Monday, August 29, 2011

Enable CLR

In SQL Server the CLR feature is "turned off by default" for some security purposes. Once you have the CLR enabled, you can write user-defined functions, triggers, stored procedures, user-defined aggregates, and user-defined types in VB.Net and C#. To enable it


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

No comments:

Post a Comment