:::: MENU ::::

Cannot create primary xml index ‘%.*ls’ on ‘%.*ls’ because PRIMARY KEY constraint contains column(s) of type timestamp.

  • Dec 17 / 2008
  • 0
Constraints and Keys, dbDigger, Indexes, XML

Cannot create primary xml index ‘%.*ls’ on ‘%.*ls’ because PRIMARY KEY constraint contains column(s) of type timestamp.

The error message
Msg 2735, Level 16, State 201, Line 1
Cannot create primary xml index ‘%.*ls’ on ‘%.*ls’ because PRIMARY KEY constraint contains column(s) of type timestamp.

is a run time error message of severity level 16. This error message appears when you try to create a XML index on a table for which the PRIMARY KEY constraint includes a column of the TIMESTAMP data type. To resolve the error make sure that the XML index is not created on the table as long as the PRIMARY KEY constraint contains the TIMESTAMP column.

Consult us to explore the Databases. Contact us