you could just used a stored procedure which will save it directly to the database, and then execute it from CF
On Thu, Mar 6, 2014 at 9:05 PM, Robert Harrison <rob...@austin-williams.com>wrote: > > Thanks everyone for the suggestions. I've tested the one at this link: > http://www.mssqltips.com/sqlservertip/1555/sql-server-find-and-replace-values-in-all-tables-and-all-text-columns/and > it works perfectly. > > I mentioned previously that I was hoping to run it in CF, and that was > partially because some of the hosts don't like to give direct access to the > data bases on their servers. Regardless, after testing I can see it's a > heavy load and have to agree with Ben Forta that it really should be run as > a query in Studio. I'll deal with getting the access I need to run directly. > > Thanks, > Robert > > Robert Harrison > Director of Interactive Services > > Austin & Williams > Advertising I Branding I Digital I Direct > 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 > T 631.231.6600 X 119 F 631.434.7022 > http://www.austin-williams.com > > Blog: http://www.austin-williams.com/blog > Twitter: http://www.twitter.com/austi > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm