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