Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  CLR Trigger and WSE 3.0 SOAP messaging

Author  Topic  dcbright Starting Member 1 Post Posted - 2009-07-29 : 10:54:19 I am working on a project that requires a SOAP message to sent when a certain condition is met within a database. The SOAP message, containing relevant information from the database, is to be sent to a web service via HTTP and will require a response status from the web service to be saved to the database. The response message will contain a status such as ‘Received’ or ‘Message syntax incorrect’ etc.. As the database is Microsoft SQL Server 2005 on a Windows 2003 platform, I thought this would be a chance to wrap the whole process up in a CLR Trigger. To send the SOAP message I want to use the SOAPSender and SOAPService classes (Microsoft's .NET Framework Web Services Enhancements 3.0 messaging API). However, my enthusiasm was soon dashed at the first hurdle. Using Visual Studio 2005 I created a new SQL Server Project and started work creating my CLR Trigger. In order to take advantage of the WSE 3 messaging API I needed to import the Microsoft.Web.Services3 namespace into the project. However when I tried adding Microsoft.Web.Services3 Reference to the project I was unable to find it in the list presented. In fact the list is very short! Is there another way I can add the WSE 3.0 reference to the project? Is it something to do with running the T-SQL command 'CREATE ASSEMBLY' on the database prior to creating the trigger? Any help would be greatly appreciated – else it's back to the drawing board!!