Does anyone have any suggestions for me on this one: I have an MS SQL 2000 DB that has 6 tables. I also have exact duplicates that I call my backup copies (or originals) of these 6 tables.
I want to allow people to modify the first set of 6 tables, but every hour I want to restore the 6 tables back to the orginal data (the data in the backup copies). What would be the quickest, easiest way to make this happen . You may have to be alittle detailed, I am slow?? I used to do this through CF by deleting all the data and then outputing the orginals and inserting ...I would assume there is a better way. The only hitch is that I also have to move orignal files and images too ... which means I would like to use the CF Schedular to do this. Anyhelp would be appreciated. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder v2.0 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
