Sample Header Ad - 728x90

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