There is a DLL that I am trying to create assembly for and call from SQL server 2008 r2 and I am getting the following message:
Msg 6544, Level 16, State 1, Line 1
CREATE ASSEMBLY for assembly 'DLLTest' failed because assembly 'DLLTest' is malformed or not a pure .NET assembly.
Unverifiable PE Header/native stub.
and the assembly creating statement is :
CREATE ASSEMBLY DLLTest
WITH PERMISSION_SET = unsafe
The following conditions are met:
> .Net 4.0
> Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
> This DLL is currently is in use in multiple VB scripts of another application.
So, to create an assembly and call the DLL at this is an issue for me IN SQL that I am trying to figure out and any assistance and help will be appreciated.