Solutions Products Download Purchase Support News Members Company
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly.
FAQs
Quick answers to common questions.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools.
Online Documentation
All of our help files for download or convenient viewing online.
Videos
Watch product demos, training videos, or tutorials of our products' main features. 

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 Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy