:::: MENU ::::

Cannot drop XML Index ‘%.*ls’ using old ‘Table.Index’ syntax, use ‘Index ON Table’ syntax instead.

  • Dec 19 / 2008
  • 0
dbDigger, XML

Cannot drop XML Index ‘%.*ls’ using old ‘Table.Index’ syntax, use ‘Index ON Table’ syntax instead.

The error message
Msg 3749, Level 16, State 1, Line 1
Cannot drop XML Index ‘%.*ls’ using old ‘Table.Index’ syntax, use ‘Index ON Table’ syntax instead.

is run time error message of severity level 16. This error message appears when you try to drop a XML index via the DROP INDEX tablename.indexname statement. To resolve the erro you should use the new DROP INDEX indexname ON tablename statement to drop a XML index.

Consult us to explore the Databases. Contact us