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.
"
How to solve thi problem?