Saturday, October 16, 2010

How to Enable CLR integration in SQL Server

This code segment explain you, How to Enable CLR integration in SQL Server using TSQL

To enable CLR integration in SQL Server, Use follwing TSQL statment.



EXEC sp_configure 'clr enabled', 1;

RECONFIGURE WITH OVERRIDE;

GO;



similarly for Disabling use follwing.



EXEC sp_configure 'clr enabled', 0;

RECONFIGURE WITH OVERRIDE;

GO ;

No comments: