There is a collation mismatch between the main instance database and the application database.

Details
Product: SQL Server Notification Services
Event ID: 1010
Source: NotificationServices
Version: 2.0.9999.9
Message: There is a collation mismatch between the main instance database and the application database.
   
Explanation
This error maps to SQL Server error 446, which indicates that the specified operation was given objects with mismatched collations.

The event log entry for this error includes the description of the actual error that caused it, which looks similar to the following:

Cannot resolve collation conflict for <operation_name> operation.</operation_name>

   
User Action
Determine the operation that failed from the event log entry and make sure that the arguments to the specified operation have matching collations. For example, if you have two columns in the same table with Greek and Latin collations respectively, a WHERE clause such as the following will cause this error:

WHERE GreekCol = LatinCol

The resulting error will have the following additional description:

Cannot resolve collation conflict for equal to operation.

The problem noted in this error must be resolved for the system to function properly.
For more information, see COLLATE in SQL Server Books Online.

Related:

Leave a Reply