A client asked me to see if I could get a copy of his old web site up and running. I did a restore of the backed up database onto my PC. The problem is that all the table names have the name of the database prepended to them.
When I view the tables in SQL Server Manager, the table, "city", is named "abc.city", where oldabc is the name of the database from which the data was backed up from. For the sake of this example, "newabc" is the database name I used on my own machine, to which the backup data was restored to. So, is there an easy way to rename all those tables? I know this is a problem because when I tested the app, it immediately threw an error because its cfquery statements were referring to table names with the database name prepended to them (ie: SELECT * FROM city, instead of SELECT * FROM oldabc.city). Thanks in advance for your help. ...lars ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
