Question:

Does 3Essential's MSSQL 2005 database servers have CLR enabled?

Answer:

Microsoft SQL Server 2005 enhances the database programming model by hosting the Microsoft .NET Framework 2.0 Common Language Runtime (CLR). This enables developers to write procedures, triggers, and functions in any of the CLR languages, particularly Microsoft Visual C# .NET, Microsoft Visual Basic .NET, and Microsoft Visual C++. This also allows developers to extend the database with new types and aggregates.

The CLR is not enabled on MSSQL 2005 by default for security reasons.  3Essentials supports this feature in the following manner:

• shared hosting: 3Essentials does not support/enable CLR on SQL 2005 shared hosting.
• dedicated server hosting: 3Essentials will enable CLR on SQL 2005 dedicated managed server hosting.