Sample SQL script to create "insert....location" command
Following sample script can be used to generate "insert...location" command
The "creator" is the owner of table(s) , value 1 is for DBA
select 'insert into ' + T.[table_name] + '_new location' + ' YOUR_SERVER_NAME_LOCATION select * from ' + T.[table_name] + char(
13) + 'go'
from systab T
where T.creator = 1