Can you dimply do a global search and replace any "dbo." In your code with "" ?
> > Now that I've created the new database and populated it with the data, > > the local code can only access those tables that are owned by dbo. > > Trying to access one of Fred's tables results in "Base table not > > found". Specifying the database name in the CFQUERY (ie select * from > > databasename.table) will make it work. Are you sure? What you're actually specifying there is owner.table . You'd need to write database.owner.table to specify the database. (I'm guessing your username is the same as your database name?) If you right-click the table > all tasks > generate sql script > preview You can view the code required to generate the table. If you run this as a query in EM, you should get dbo as the owner I think. Then you can SELECT * INTO newTable FROM oldTable. Is this the best way? Probably not. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
