SELECT SERVERPROPERTY('Collation') AS 'Collation'
SELECT name, collation_name FROM sys.databases
The JDE Database Collation level should be Latin1_General_CI_AS_WS
msdb SQL_Latin1_General_CP1_CI_AS
DBA SQL_Latin1_General_CP1_CI_AS
JDE920 Latin1_General_CI_AS_WS
JDE_CRP Latin1_General_CI_AS_WS
JDE_DEVELOPMENT Latin1_General_CI_AS_WS
JDE_DV920 Latin1_General_CI_AS_WS
JDE_PRIST920 Latin1_General_CI_AS_WS
JDE_PS920 Latin1_General_CI_AS_WS
JDE_PY920 Latin1_General_CI_AS_WS
JDE_PD920 Latin1_General_CI_AS_WS
JDE_PRODUCTION Latin1_General_CI_AS_WS
