Look into calling a web service from a CLR. It'll be a hack job and will require some C#, but the database doesn't generally initiate communication with the application layer.
Ideally, if additional processing needs to occur any time certain data is changed, that sort of stuff should probably be routed through your application's service layer. ~Brad -------- Original Message -------- Subject: (ot) How to call a .cfm page from a MS SQL Server trigger or stored procedure From: Michael Reick <mich...@widgethq.com> I've done a ton of Googling, (is that a word??) and so far I can't find the answer, so I figured I'd ask here. I've got a trigger that runs when certain tables are updated, which updates some other tables, but I'd like it to call a .cfm page (either on the database box or a different box) that does some other tasks. Is this possible? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
