Section 4.2. Enabling CLR Integration

4.2. Enabling CLR Integration

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

Programming SQL Server 2005
Programming SQL Server 2005
ISBN: 0596004796
EAN: 2147483647
Year: 2007
Pages: 147
Authors: Bill Hamilton © 2008-2017.
If you may any questions please contact us: