:::: MENU ::::

Posts Categorized / SQL Server logs

  • May 06 / 2014
  • 0
CLR, dbDigger, High Availability, SQL Server Clustering, SQL Server logs

Using ‘odsole70.dll’ version ‘2009.100.1600’ to execute extended stored procedure ‘sp_OACreate’

Recently we came across unexpected cluster fail over of one of our servers. It was required to get the exact reason for it. I analyzed the sql server and windows logs. There was no traces of failure neither i found any major issue in the logs that may lead to fail over. However an entry in the logs caught my attention and it was following message

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.

I googled it and came to know that it is culprit of event. According to its BOL page

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.

Note This issue also occurs when a CLR object calls a Transact-SQL procedure that calls Automation procedures.
It applies to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. More detail can be found here.
Now we have to trace the call and modify it to avoid the accidental fail over.

  • Feb 28 / 2012
  • 0
dbDigger, Monitoring and Analysis, Reference Articles Archival, SQL Server logs, System Stored Procedures, T-SQL Tips and Tricks

Reading SQL Server logs by using T-SQL

SQL Server logs are valuable way to analyze condition and activities on SQL Server. Activities may be related to logins, sessions, backups, permission errors etc. SSMS GUI provides way to read SQL Server logs however also there are powerful T-SQL alternates that provide facilities filters for dates, keywords and specific log files. Click here to read a very well written article about reading SQL Server logs through T-SQL. Also do not forget to read valuable comments under this article.

Consult us to explore the Databases. Contact us