Copying Tables and Data

Is there any simple way to copy tables from one database to another in SQL Management Studio or VS 2005? I sometimes work split work between home and work and I often need to copy and table and its data (data, stored procedure, etc) to a different database, but having to create a new database then copy the data is a pain.

Is there an easier way?

You can back up and restore the DB. Less painful than copying each table.

|||

I apologize ndinakar, what I meant was a need a way of copyingtables, not databases, between databases.

|||

You can use SELECT INTO to copy table along with data in it to another location.

|||

Or you can BCP OUT the data into text files, carry them home and BCP IN into the destination tables.

|||

Thanks guys, exactly what I needed.