If you have the table structure already created in the target database, you
can use 3 part notation to reference the tables:

INSERT INTO DatabaseB..Table (<columns>)
SELECT <columns> FROM DatabaseA..Table;

Note this assumes default schema for the user. If you have specific schema
names you should reference it:

INSERT INTO DatabaseB.schema_name.Table (<columns>)
SELECT <columns> FROM DatabaseA.schema_name.Table;

You can use SELECT INTO if the target table does not exist, but that will
not copy any constraints or indexes. Best is to script the table and create
in advance, then insert the data.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

You can use the Import/Export wizard from Management Studio. Right click on a
database -> Tasks -> Import Data ..., and follow the GUI.

Linchi