Is it possible to invoke WF from an update to a SQL table

Question

I want to create a web application that invokes an approval process when an update is made in a separate application.  The separate application is from a 3rd part vendor but has a sql backend.  Within the the SQL there is a table that I want to kick off a process every time something is inserted into it.  I want to know the following.

1. Is it possible to invoke an approval workflow without writing a trigger on the table (therefore invalidating the 3rd party support agreement).  Is there another way to listen to the table?
2. can the workflow be invoked from a change made in  SQL Table?

it would be handy to see an example of question 2

Many thanks in advance for your help.

---

Kev

Answer 1

Hi,

I'd suggest you check the discussion in the following thread. Basically, we must manually combine the code of monitor database and control workflow.

Start workflow on database update

http://social.msdn.microsoft.com/forums/en-us/wfprerelease/thread/2620E8A3-7AEA-410E-95B0-82B40BE20CC8

---

Leo Tang [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.