We're doing a copy table with the following script:
DELETE DATA db2.dbo.temp
INSERT INTO db2.dbo.temp
select * from db1.dbo.ppemp
We get the following message:
Server: Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'datebase.dbo.table' can only be specified when
a column list is used and IDENTITY_INSERT is ON.
It's a lot of tables we need to do 'set' this column, so:
- How can we display or know which column have ' identity column'?
- How de we 'set' these columns OFF and then ON?