LINKS  

ApexSQL Knowledgebase

Tips and How-to Articles for ApexSQL Tools


How to enable execution of user code in the .NET Framework

DESCRIPTION
This article will show you how to enable execution of user code in the .NET Framework and avoid message “Execution of user code in the .NET Framework is disabled. Enable ‘clr enabled’ configuration option” in ApexSQL products.

SOLUTION
In Microsoft SQL Server 2005.
1. Explore "Microsoft SQL Server 2005/Configuration Tools/SQL Server Surface Area Configuration" in your Start menu.
2. Select "Surface Area Configuration for Features"
3. You will find "CLR Integration" option, activate it and save.

Another way to enable this feature is with SQL (using SQL Server Management Studio).

sp_configure 'show advanced options', 1;
GO

RECONFIGURE;
GO

sp_configure 'clr enabled', 1;
GO

RECONFIGURE;
GO



The error message will no longer appear in ApexSQL products.

SEE ALSO
General FAQs

AUTHOR
Evgeniy Spashko

LAST REVIEW DATE
24 Sep 2009

Labels:



© 2010 ApexSQL LLC All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy