Enabling CLR in SQL Server

 

Question:

How do I enable CLR in SQL Server?

 

Answer:

Run the following query inside SQL Server Management Studio (SSMS):

    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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us