Error When Creating CLF Function

Posted by Julio Miranda on Stack Overflow See other posts from Stack Overflow or by Julio Miranda
Published on 2009-06-26T13:23:49Z Indexed on 2010/04/08 4:03 UTC
Read the original article Hit count: 438

Filed under:

sqlclr

I've created an C# class that contains 2 static method and I successfully created an Assembly in SQL 2005. When I try to create a table-valued function from that Assembly I get the following error:

Msg 6509, Level 16, State 36, Procedure , Line 2 An error occurred while gathering metadata from assembly '' with HRESULT 0x80004005.

We have other CLR functions that are that are with in the same dll and seem to work fine. I tried to emulate what the other functions are doing, but I can't seem to get this function to work.

All the documentation online doesn't seem to help

Related posts about sqlclr

Visual Studio 2010 and SQLCLR: Some Good, Some Bad

as seen on SQL Blog - Search for 'SQL Blog'
This past week I've been trying out Visual Studio 2010 for SQLCLR development. Verdict: A couple of nice things, a couple not so nice. In the interest of keeping things somewhat positive around here, we'll start with the good stuff : Pre-deployment and post-deployment scripts are built in. This is… >>> More
SQLCLR and DateTime2

as seen on Stack Overflow - Search for 'Stack Overflow'
Using SQL Server 2008, Visual Studio 2005, .net 2.0 with SP2 (has support for new SQL Server 2008 data types). I'm trying to write an SQLCLR function that takes a DateTime2 as input and returns another DateTime2. e.g. : using System; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; namespace… >>> More
SQLCLR using the wrong version of the .NET Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
During a recent restart of our development server the SQL Server started using .NET 4.0 for the SQLCLR. This means that nothing using the CLR in SQL works, or at least that's my understanding by reading these sources: http://software.intel.com/en-us/blogs/2009/10/16/sql-server-2008-sqlclr-net-framework-version/ www… >>> More
SQL Server 2008 SQLCLR Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQLCLR that was originally running on SQL Server 2005 DB. I have since rebuilt the CLR to run on SQL Server 2008. The CLR requires a reference to WindowsBase.dll. I added WindowsBase.dll as an assembly to the SQL Server 2008 DB. When I try to use the rebuilt CLR I get the message Could… >>> More
SQLCLR function to return free space for all drives on a server

as seen on SQL Server Central - Search for 'SQL Server Central'
When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR. >>> More

Developer IT