I have a CLR based stored procedure which used MsmqIntegrationBinding
to post messages to remote MSMQ's. Everything was working fine in SQL Server 2005 but now there is an upgrade from 2005 to 2012 suppose to happen. I tried to register the CLR (SP) in SQL Server 2012 but while registering System.ServiceModell.DLL
it came up with the following error.
Msg 6544, Level 16, State 1, Line 1
CREATE ASSEMBLY for assembly 'System.ServiceModel' failed because assembly 'microsoft.visualbasic.activities.compiler' is malformed or not a pure .NET assembly. Unverifiable PE Header/native stub.
I searched for the resolution and it appears that few other people are having the same problem and as of now there is no solution to it.
The primary reason for using MSMQIntegrationBinding
is we wanted to make sure that each message is delivered only once. As you can see that I was pretty much interested in the ExactlyOnce
property which is not there in the normal system.messaging class. We process thousand of messages and ordering of messages is very important further more each message is stamped with an id and if any message is sent which has an id that is less than the message previously sent the client system halts (big problem).
I also have rewritten the CLR stored proc using system.messaging. I just need suggestions whether it can support the scenario I mentioned above.