Wantt to copy of table data to another database table

Question

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?

Suthish Nair · Answer

Abdu why you creating so much duplicate threads?

Soft Corner · Answer

Hi It can mean two things : 1. One you've not enabled identity insert on your table meaning SQL Server will not let you insert into the Identity column. This can be rectified with the following statement: SET IDENTITY_INSERT table_name ON And then turn it off again when done SET IDENTITY_INSERT table_name OFF 2. However it can also mean that you are using for example INSERT INTO in which cause the message tells you to specify the column names. This means using the following syntax: INSERT INTO target_able_name ( column_name1  column_name2…. column_nameN ) SELECT YOUR_SELECT_LIST_WHICH_MATCHES_COLUMN_LIST FROM source_table_name