If you mean 'insert all rows from a table in database A into an
indetical table in database B', then yes.
If both databases are in the same server, just do a direct 'insert A..table_X select * from
If they're in different servers, you must create a prroxy table first, and then you basically do the same.
You can generate the required SQL statements by querying sysobjects directly.