I want to be able to bulk copy all the tables in the database and rename them at the same time. I currently have code that finds all the tables in a database, loops through and does this:

EXECUTE ('SELECT * INTO x_' + @tablename + ' FROM ' + @tablename)

Whilst this works ok, I have 2 problems.

1) Takes a long time
2) Fills up transaction logs.

Is there a way that could do it quicker and/or not do any logging?

I also want to copy all the tables in 1 database into a newly created database but rename the tables at the same time. Is this possible using Stored Procedures?

Many Thanks