MsSql: How to enable clr (to run c# / vb code in SQL)

Execute the next query to enable CLR.  

[code:c#]

// Turn advanced options on

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

[/code]

More info about CLR on Microsoft MSDN.

Leave a Reply

Your email address will not be published.