JavaScript Editor Ajax toolkit     Ajax tutorials 



Main Page

Previous Page
Next Page

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.


Previous Page
Next Page


JavaScript Editor Ajax toolkit     Ajax tutorials 
http://www.cashadvance-loans.net/pennsylvania/cash-advance-state-college-borough-pa/ . Bitcoin Dice - Crypto Casino