I am trying to start a simple email process using an SQL trigger.
Firstly i created the parts seprately:
- Set up a CLR job to Select the Inserted records
- Created a Console application which starts a K2 process
When bringing the two together, i get the following error when trying to Create the Assembly on database server.
Create Assembly Code:
CREATE ASSEMBLY Incident
FROM 'E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnTestClassLibrary1.dll'
WITH PERMISSION_SET = UNSAFE
Error:
Msg 6544, Level 16, State 1, Line 1
CREATE ASSEMBLY for assembly 'ClassLibrary1' failed because assembly 'sourcecode.hostclientapi' is malformed or not a pure .NET assembly.
Unverifiable PE Header/native stub.
Any input would be greatly received
Regards
Matt Warman