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
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