I have a vbs script that takes a URL as an input that I can call from SQL Server to execute Web code. However, I wouldnt call this script inside of a trigger and would be concerned about holding open the database transaction. You would probably want a solution that would allow the transaction to close quickly and allow the desired process to run in the background. If you want something that will rollback the transaction if the Web code fails, then maybe you do want to hold open the transaction. Otherwise, the technique that comes to mind is to write an entry to a database table and have a scheduled task query that database table looking for records to process. You could also look into using the SQL Service Broker.
-Mike Chabot On Fri, Aug 14, 2009 at 5:13 PM, Michael Reick<[email protected]> wrote: > > 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? > > Specifics: > DB Server: MS SQL Server 2005 > OS: Windows 2003 > > Thanks! > > Michael Reick > > > __________ Information from ESET NOD32 Antivirus, version of virus signature > database 4336 (20090814) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
