how to copy tables and its data with procedures etc to another database in MS sql 2005

i want to copy some tables from 1 database to another with its data & procedures etc to another database in Microsoft SQL 2005.

can any one help

plz reply

tnx alot

If you need the data then there is no way to use SQL: Scripting but you can backup the database and restore it in the other place.

Another solution is to use the copy database (copy between instances) or the DTS.

Let me know if you need further info.

Regards

|||

Thanx brother for Repy !

DTS services are in Sqlserver2000 enterprise manager for using them it is necessary to attach my .mdf file in sqlserver2000 but when i try to attach an mdf file created from sqlserver2005 express edition i am getting error message and i cant use backup feature because i want to move only some tables along with their data to another database not duplicating the same database.

|||

When you install mssql 2005 on an exisiting version of mssql 2000 the DTS will be upgraded.

If you don't want to waste your time in DTS, create a backup of the db and restore it in the other db,

Regards

|||

backup/restoring method not workng, it gives error messge as " backupset holds the backup of database other than the existing"

tnx for reply

|||How did you do that? Let me know what you have done step by step.