Jaa


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).

Options

  • 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.

See Also

Concepts

Surface Area Configuration for Features
Surface Area Configuration for Services and Connections

Help and Information

Getting SQL Server 2005 Assistance