Hello,
Does anyone have a recommended best practice for how a workflow should "watch for" the event of a SQL (2005) trigger's firing -- rather like the FileWatcher sample
Or better, perhaps a code sample
Thanks in advance for your thoughts.
John
Windows Workflow Foundation
Hello,
Does anyone have a recommended best practice for how a workflow should "watch for" the event of a SQL (2005) trigger's firing -- rather like the FileWatcher sample
Or better, perhaps a code sample
Thanks in advance for your thoughts.
John
How about using a While activity that looks for some value that the trigger sets in the DB Then you would just need some way to capture your trigger value ...
Dave
Hello, Maurice (and thanks also to all who responded) ...
Testing here indicates that the SQL Dependency approach, hooked into a Windows Service, is viable. I'm also looking at going the SQL Service Broker route. When I have some comparative performance info, and have reasonably packaged the code, I'll post it.
In the meantime, if you have code/thoughts, please let me know.
Thanks again,
John