Learn: How to Enable/Disable clr in Sql server

Tuesday, 18 February 2014

Today I am going to explain very important feature of sql server 2008. Now we have an option

for Enable/Disable of CLR .

We can prevent any DDL(CREATE/DROP) operation in sql server database Just the help of this option.

sp_configure 'clr enabled', 0
GO
RECONFIGURE
GO

run above code in sql query window.From this query we can disable clr. Now run,

create table test
(
abc varchar(10)
)

drop table test

a msg will throw...

"Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option"

Because we have disabled clr option before.Now Run,

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

above query again enable your clr. Now you can perform any DDL operation.

Learn