icelava.net

My colleague hit a mysterious error message whenever she attempted to deploy the assembly compiled with our managed stored procedures to the SQL Server.

An error occurred while gathering metadata from assembly 'Assembly.Name' with HRESULT 0x80004005. ProjectName

It always failed at a particular stored procedure when it gives up, and she found out it was due to the stored procedure method being written to return a DataTable instead of void. Looks like Visual Studio or C# compiler cannot readily point this out when methods are laced with the SqlProcedureAttribute.

Thanks, I got the same error while deploying. Any idea why this is happening?

If my last paragraph does not describe the situation you are in, then your issue lies in a different realm.

Moin Moin.

By the way, does anyone know of a registration-page here.

However, The aforementioned error persists upon using an SqlFunction :

i.e. public partial class tabular_EventLog//Assemblies do not like encapsulating "namespace"s.
       {[SqlFunction(FillRowMethodName="FillRow")]public static IEnumerable InitMethod(String logname) {...}

        public static EventLogEntry FillRow( Object object_to_enter_into_resulttable
                                            ,out SqlDateTime Time_written,out SqlChars message,out SqlChars category,out long Instance_ID
                                           ){...}

 

Are you supposed to use the SqlFacetAttribute class when returning a .NET type? Taking a guess here.