5209 AE_COLLATIONS_DO_NOT_MATCH

Advantage Error Guide

Problem: A table was opened that has one or more indexes built with collations that do not match the currently specified collation.

Solution: The purpose of this error is to raise visibility to the potential optimization problems that can occur when dynamic collations are used. For example, if the static OEM collation is currently being used and a table has an index built using MACHINE_VFP_BIN_895, then this error will be generated when the table is opened. This can be avoided by specifying the appropriate dynamic collation for the table or SQL statement.

If an application needs to use multiple collations concurrently on a single table, this error can be turned off with the sp_AllowMultipleCollations system procedure.