I can't say I've ever seen that one before, but you could just do a loop over the contents of INFORMATION_SCHEMA.TABLES and build/exec an ALTER statement for each one.
http://technet.microsoft.com/en-us/library/ms190273.aspx How many tables are there? If there are under 75, you might be just as fast renaming them them by hand. ~Brad -------- Original Message -------- Subject: SQL Server question re table names From: "Larry Soo" <l...@bc4x4.com> Date: Tue, December 08, 2009 1:45 pm To: cf-talk <cf-talk@houseoffusion.com> 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4