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?
Wantt to copy of table data to another database table
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
"
How to solve thi problem?
i tried to copy , but i get error message
"
How to solve thi problem?
Suthish NairPosted Mar 10, 2011, 1:56 PM
Soft CornerPosted Mar 10, 2011, 12:53 AM
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