How to determine the collation for all Microsoft SQL Server databases


Microsoft FRx uses several databases when retrieving data for its reports. Those database must have the same collation or an error will occur. This article provides a SQL statement that can be used to check the collation of all databases within a Microsoft SQL Server installation to quickly identify those which have differing collations.

More Information

To determine the collation for all databases within a SQL Server installation, run the following query using Microsoft Query Analyzer or any other SQL tool:

select name, databasepropertyex(name, 'collation') from master..sysdatabases



Artikel-id: 964958 - Laatst bijgewerkt: 26 jan. 2009 - Revisie: 1