Enabling CLR Integration

On 13 Sep, 2015

By : Charith Silva

No Comments

The common language runtime (CLR) integration feature in SQL Server is off by default, Below SQL Script will help you to enabled CLR in order to use objects that are implemented using CLR integration. When CLR feature enabled in SQL Server, you can now write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.

sp_configure 'show advanced options', 1; 
GO 
RECONFIGURE; 
GO 
sp_configure 'clr enabled', 1; 
GO 
RECONFIGURE;

sp_configure 'show advanced options', 1;

RECONFIGURE;

sp_configure 'clr enabled', 1;

RECONFIGURE;

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva