Article ID: 922672 - Last Review: February 14, 2011 - Revision: 3.0

Support policy for untested .NET Framework assemblies in the SQL Server CLR-hosted environment

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

INTRODUCTION

This article describes the support policy for untested Microsoft .NET Framework assemblies in the .NET Framework common language runtime (CLR)-hosted environment in Microsoft SQL Server.

MORE INFORMATION

When you register an assembly that references an untested .NET Framework assembly in SQL Server, you may receive the following warning message:
Warning: The Microsoft .Net frameworks assembly 'AssemblyName' you are registering is not fully tested in SQL Server hosted environment.
The message means that the .NET Framework assembly has not been tested in the SQL Server CLR-hosted environment. Therefore, the assembly is not supported in the SQL Server 2005 CLR-hosted environment.

An untested .NET Framework assembly may decide to exit its host process when a critical condition such as low-memory condition occurs. You can use the assembly in the SQL Server 2005 CLR-hosted environment at your own risk. However, Microsoft SQL Server Product Support Services (PSS) will not help you use and troubleshoot issues that are associated with an unsupported .NET Framework assembly. If PSS determines that a particular unsupported assembly causes SQL Server issues, you may be asked to stop using the assembly. Additionally, you may be asked to stop using the assembly temporarily when PSS troubleshoots a particular SQL Server issue if it is necessary.

Additonally, you must maintain these assemblies after you upgrade the Microsoft .NET Framework. For more information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:
949080  (http://support.microsoft.com/kb/949080/ ) Error message when you execute a CLR routine or use an assembly in SQL Server 2005: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)"


The following .NET Framework assemblies are supported in the SQL Server CLR-hosted environment:
  • Microsoft.VisualBasic.dll
  • Mscorlib.dll
  • System.Data.dll
  • System.dll
  • System.Xml.dll
  • Microsoft.VisualC.dll
  • CustomMarshalers.dll
  • System.Security.dll
  • System.Web.Services.dll
  • System.Data.SqlXml.dll
  • System.Transactions.dll
  • System.Data.OracleClient.dll
  • System.Configuration.dll

APPLIES TO
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Compact Edition
Keywords: 
kbhowto kbexpertiseadvanced kbsql2005clr kbinfo KB922672