> > > I have a two identical databases on different sql boxes. One > > > primary and > > one back up. I would like to be able to do something like this in > > the application.cfm
You should use an automatic failover. A quick search on the all knowing oracle revealed this gnomic answer " I think that "Merge replication with updating subscribers" should work for you: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql /reploptions_34hf.asp Cheers" And "http://doc.ddart.net/mssql/sql70/2_003_16.htm"; These are sql server specific, as you don't seem to identify which product you are using. Jon. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
