How to configure CLR for SQL Server?
CLR integration is off by default in SQL Server. We need to set it on using the following statement:
Sp_configure ‘clr enabled’,1
GO
RECONFIGURE
GO
How to configure CLR for SQL Server?
CLR by default is not configured in SQL server. It needs to be explicit ally configured using sp_configure syntax.
This is shown as below:
Sp_configure 'clr enabled', 1
RECONFIGURE WITH OVERRIDE
Here, 1 is the configuration setting.