Copy one database table to another database
How to copy one database table to another database(with all things like procedure,Trigger etc).
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Chetan KumarPosted Oct 22, 2012, 7:28 AM
U can do through import /export wizard .
Right click on database go to task there u can find this option
Santhosh Kumar JayaramanPosted Oct 22, 2012, 7:27 AM
you need to say script triggers=true in advance scripting option window.
Remember stored procs are not at table level.they belongs to DB