The common language runtime (CLR) integration feature is off by default, and must be enabled in order to use objects that are implemented using CLR integration. To enable CLR integration, use the clr enabled option of the sp_configure stored procedure:

Code Snippet

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

Note

enabled = 1 disable = 0 To enable CLR integration, you must have ALTER SETTINGS server level permission, which is implicitly held by members of the sysadmin and serveradmin fixed server roles.


Reference/Credit

http://msdn.microsoft.com/en-us/library/ms131048.aspx




author's photo

Author : Blue Cloud

Just a normal software developer who love to write code. Developing professional software since 1999. After working in the software industry for many years, I've started my own website to share knowledges and experiences.

COMMENTS
blog comments powered by Disqus