This documentation is archived and is not being maintained.

Surface Area Configuration for Features (CLR Integration) - Database Engine

Execution of user assemblies inside Microsoft SQL Server 2005 is disabled by default. Use this dialog to configure support for the common language runtime (CLR).

Enable CLR integration

If checked, you can use CLR-based user-defined functions, procedures, triggers, and types from within the Database Engine.

Even if this option is disabled, you can run data definition language (DDL) statements to create, alter, or drop user assemblies and CLR modules, but you cannot execute the CLR code.

For more information about CLR integration, see Building Database Objects with Common Language Runtime (CLR) Integration in SQL Server Books Online.

For more information about configuring server options, see sp_configure (Transact-SQL) in SQL Server Books Online.