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

LINKS

General

ApexSQL Audit
ApexSQL Clean
ApexSQL Data Diff
ApexSQL Debug
ApexSQL Diff
ApexSQL Diff API
ApexSQL Doc
ApexSQL Edit
ApexSQL Enforce
ApexSQL Log
ApexSQL Log API
ApexSQL Recover
ApexSQL Refactor
ApexSQL Script
ApexSQL Source Ctl
ApexSQL SSIS Compare

Knowledgebase Home

SITE FEED

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: Apex SQL Data Diff

posted by Evgeniy Spashko on Thursday, September 24, 2009

0 Comments: