:::: MENU ::::

Cannot add identity column, using the SELECT INTO statement, to table ‘%.*ls’, which already has column ‘%.*ls’ that inherits the identity property.

  • Jan 17 / 2009
  • 0
dbDigger, Identity Columns

Cannot add identity column, using the SELECT INTO statement, to table ‘%.*ls’, which already has column ‘%.*ls’ that inherits the identity property.

The error message
Msg 8108, Level 16, State 1, Line 1
Cannot add identity column, using the SELECT INTO statement, to table ‘%.*ls’, which already has column ‘%.*ls’ that inherits the identity property.

is a run time error message of severity level 16. This error message can appear on all versiond of SQL Server when you try to execute a SELECT INTO statement in which you use the IDENTITY function although the table you select from already contains a column with the IDENTITY property that the same column in the new table will inherit.
As Every table can contain only one IDENTITY column. You must remove the IDENTITY function from the SELECT INTO statement to avoid the error.

Consult us to explore the Databases. Contact us