Copy one database table to another database

Question

How to copy one database table to another database(with all things like procedureTrigger etc).

Chetan Kumar · Answer

Hi U can do through import /export wizard . Right click on database go to task there u can find this option

Santhosh Kumar Jayaraman · Answer

http://csharpdotnetfreak.blogspot.com/2012/07/copy-database-table-to-another-sqlserver.html y ou need to say script triggers=true in advance scripting option window. Remember stored procs are not at table level.they belongs to DB