That would alos be a good solution.  Since I have a select statement that defines the tables I need to copy, I can pass the list to a table, temp...

That would be a great solution if I knew anything about scripting.

Some of you talk like all DBA's have to be guru's to carry the title. Not so. If you need a guru for a senior position hire the...