4.2. Enabling CLR IntegrationCLR integration is turned off by default in SQL Server 2005. Use the sp_configure system stored procedure to enable CLR integration, as shown here: sp_configure 'clr enabled', 1 GO RECONFIGURE GO The clr enabled server configuration option specifies whether .NET assemblies can be run by SQL Server (0 = do not allow; 1 = allow). The change takes effect immediately after sp_configure and reconfigure are executedthe server does not need to be restarted. You need ALTER SETTINGS permissions at the server level to enable CLR integration. |