Copy table into different database

Hello, I have a table that I would like to copy into a different database. I'm using SQL Server 2005. The reason I don't just copy the data with "SELECT * FROM..." is because the desired table doesn't exist yet. It has ~50 columns and I'd rather not recreate them all (I didn't design it). Thanks.

What is the source of the table?

You can either use DTS to Import the table in a database in SQL Server 2005 or do Detach-Attach.

If you want to use Detach-Attach, right click the table in your source server and click Detach. Then you can attach this table to your destination.

bullpit

|||

Check this article for Detach-Attach

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx

bullpit

|||

in sql enterprise manager, you can select a table, right click, select copy.
then open query analyzer on the target database and open a new query window - now right click/paste
you should see the table create script which you can run to create the table in the target db.

additionally, you can import objects from enterprise manager (right click the target db and select Import).
By importing the object, you get the schema, and all data.

|||Using Management Studio, I couldn't right-click copy. After trying to figure out a script I could write, I right-clicked the database >> Tasks >> Import Data... no problem from there. Thanks for the tip!