Ran into this issue when attempting to execute sp_CheackBackup on a server that is hosting SSRS databases.
Msg 446, Level 16, State 11, Line 9
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in add operator for DISTINCT operation.
Msg 446, Level 16, State 11, Line 9
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in add operator for DISTINCT operation.
Msg 446, Level 16, State 11, Line 9
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in add operator for DISTINCT operation.
Ran into this issue when attempting to execute sp_CheackBackup on a server that is hosting SSRS databases.
Msg 446, Level 16, State 11, Line 9
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in add operator for DISTINCT operation.
Msg 446, Level 16, State 11, Line 9
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in add operator for DISTINCT operation.
Msg 446, Level 16, State 11, Line 9
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in add operator for DISTINCT operation.