Wantt to copy of table data to another database table

Mar 10 2011 12:05 AM

I already copied tables only with schema from one database.Now iwant to copy data .In data there is identity column.How to copy data only ?

i tried to copy , but i get error message

"

An explicit value for the identity column in table 'Dbname.dbo.tbl can only be specified when a column list is used and IDENTITY_INSERT is ON.