copy table from one database to another database

You can use three-part qualifier to access table in different databases:

INSERT INTO DestinationDB.dbo.Table
   (Col1, Col2, ....)
SELECT Col1, Col2, ....
FROM SourceDB.dbo.Table

---

Olaf Helper

[ Blog] [ Xing] [ MVP]