INSERTINTO db2.dbo.table2 SELECT * FROM db1.dbo.table1
>I wish to copy records from a table in one database (db1.table1) to a similar table in another database (db2.table2), but I am not sure about the syntax. > >I guess it would go something like... >INSERT INTO db2.table2 (SELECT * FROM db1.table1), but this does't work. > >Any help would be appreciated. > >Alan