I need to copy tables to other database in mssql

Thanks everyone

If they are on the same server, and you want the data to always be the same on both db's, rather than copying, you can just use the original table for the other database.

If it's a one time copy, ask your dba to back up the table to the new db.   That's what we do with both mssql and oracle.

This is OK, you have one more solution as well.

Create SQL script of the table on db1 and run on db2. It will create the same table schema on db2.

To copy date, we can use this,

SELECT * INTO db1.dbo.tablename FROM db2.dbo.tablename

Thanks

Sankalan

Mindfire Solutions