Pineapple-lumps comments

Repositories
Issues
Comments

Results 2 comments of


                                            Pineapple-lumps

serverproperty('servername') output changed from 2019 RTM to CU18 and leads to backup error on case sensitive instances

I had a similar issue with Integrity checks. Same logic. I changed mine to (covers both bases): IF **UPPER**(@@ServerName) **UPPER**(CAST(SERVERPROPERTY('ServerName') AS nvarchar(max))) AND SERVERPROPERTY('IsHadrEnabled') = 1 My @@servername was lower,...

DBCC check fails due to case difference in server name on CS collation server

> Thanks IverJoc. I'd modified the SP to use UPPER on both values. Which essentially does the same thing. Good tip about changing the db collation. I assume you haven't...