You are currently offline, waiting for your internet to reconnect

Crash occurs when you call Automation procedures from CLR Objects in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Assume that you are running Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012. You call some Automation procedures from a SQL Server common language runtime (CLR) object, such as sp_OACreate. In this situation, SQL Server may unexpectedly crash. Additionally, an error message that resembles the following is logged in the application event log: 

Information <Time stamp>Windows Error Reporting 1001 None
Fault bucket , type 0
Event Name: APPCRASH
Response: Not available
Cab Id: 0

Problem signature:
P1: sqlservr.exe
P2: 2009.100.4000.0
P3: 4fecc5ba
P4: StackHash_b620
P5: 6.1.7601.17725
P6: 4ec4aa8e
P7: c0000374
P8: 00000000000c40f2

Note This issue also occurs when a CLR object calls a Transact-SQL procedure that calls Automation procedures.
To work around this issue, do not directly or indirectly call Automation procedures from any SQL Server CLR objects.
More information
When an application calls Automation procedures, a message that resembles the following is logged in the SQL Server log:

<Time stamp> spid365 Using 'odsole70.dll' version '2009.100.1600' to execute extended stored procedure 'sp_OACreate'. This is an informational message only; no user action is required.

When an application calls the SQL Server CLR, a message that resembles the following is logged in the SQL Server log:

<Time stamp> spid313 Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from <%windir%>\Microsoft.NET\Framework64\v2.0.50727\.

Note The previous messages do not indicate that CLR objects call Automation procedures.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Article ID: 2796944 - Last Review: 01/10/2013 08:09:00 - Revision: 1.0

Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2012 Enterprise

  • kbsurveynew kbtshoot kbexpertiseadvanced KB2796944