sp_Blitz fails with collation error
4
votes
2
answers
506
views
> SQL Server version (output from select @@VERSION): Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0.3281.6 (X64) (Build 14393: )
Installed
sp_Blitz
from Brent Ozar, stored procedure creates successfully.
Version info from the code: SELECT @Version = '7.93', @VersionDate = '20200217';
The instance has the 4 system DBs with collation SQL_Latin1_General_CP1_CI_AS
and 2 user databases with collation SQL_Latin1_General_CP1_CS_AS
When I try to run sp_Blitz
I get this:
> Msg 468, Level 16, State 9, Procedure sp_Blitz, Line 896 [Batch Start Line 0]
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Appreciate any assistance in troubleshooting (I'm mainly an Oracle guy who's been handed a SQL Server for review and remembered this as a thing that might be a good start for obvious things to start with).
Asked by SJWales
(109 rep)
Feb 20, 2020, 06:38 PM
Last activity: Feb 22, 2020, 04:18 PM
Last activity: Feb 22, 2020, 04:18 PM