SA0059A : Check database for objects created with different than default or specified collation

The topic describes the SA0059A analysis rule.

Message

Check database for objects created with different than default or specified collation

Description

The rule checks database for objects created with different than the database default or the specified collation.

How to fix

Review the database object and reason it has different collation than the current database’s default collation. Consider recreating the object with the default collation.

Scope

The rule has a ContextOnly scope and is applied only on current server and database schema.

Parameters
Name Description Default Value
Collation

Specific collation to check for.

Database Collation
Remarks

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Effort To Fix
13 minutes per issue.
Categories

Design Rules, Bugs

Additional Information

There is no additional info for this rule.

See Also

Other Resources

Analysis Rules