Taryn Pratt goes into a change in the sys.syslogins
system view in SQL Server 2019:
Sigh ok, something is really broken because this was working before we failed over.
The code for the login replication basically does the following via a cursor (yeah, I know, but it works…normally):
1. Select from the primary via
OPENQUERY
to query the logins and passwords
2. Usingsp_hexadecimal
convert thevarbinary
password to astring
value
3. Create a string to be executed, i.e. dynamic SQL that runs aCREATE LOGIN
Read on for the whole story and how you can protect yourself as you upgrade to SQL Server 2019.