Name: Collation check
Platform: Sqlserver
Category: Availability
Description: Checks if there is a collation conflict with temp tables and table variables.
Long description: You may get a collation conflict when the collation of your user database does not match the collation of tempdb database. Whenever you join with the temp table (without specifing the collation for string columns) they will inherit the default collation for tempdb databae causing collation conflict.
Version: 1.4
Default schedule: 30 7 7 *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2000’ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment