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.
Comments closed