Copy / Paste Database?

[jalbao]

Is is possible to simply copy a table from one database and paste it into another database?

 

[jalbao]

sorry - i forgot to mention that i am running sqlserver 2000

 

[yogeshc]

Try using Data Transformation Services... in enterprise manager it is under tool, data transformation services -> import data

 

[cdukes]

Alternatively, create a script of the table and then run the script on the other database. ( this is all that DTS actually does ), but at least you have a copy of the script at the end of the day.

Chris