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
 .NET Inside SQL Server (2005)
 Calling a WCF service from a Table Trigger

Author  Topic 

AKF
Starting Member

1 Post

Posted - 2010-05-20 : 23:02:21
I have a need to call a WCF service from an update table trigger in SQLServer 2008. I would like to write a ASP.NET assembly to load into the database. Parameters for this call are minor (an int and string).

Has anyone any sujections or warning for me in this.


concoran
Starting Member

7 Posts

Posted - 2010-05-25 : 15:24:39
You can use CLR integration in SQL SERVER 2005. Check this article out.
http://www.devsource.com/c/a/Using-VS/Introducing-SQL-Server-2005s-CLR-Integration/

Basically, you would write a stored procedure in .NET in which you would call WCF Server. In your update trigger you can then call .NET assembly.
Go to Top of Page
   

- Advertisement -