Скачать или смотреть SQL Server Always on Logins Sync to Secondary Replicas

Join the group to get your copy of scripts:
https://chat.whatsapp.com/KPXLozGtE9C...

U can download from the link:
https://www.mediafire.com/file/xopw89...

Note:
1.Stored Procedure sp_help_revlogin:
This procedure generates a script that can be used to recreate SQL Server logins, including their passwords, SIDs, and other properties.

2.Stored Procedure sp_help_revlogin2:
This procedure is similar to sp_help_revlogin but stores the generated script in a temporary table #Command instead of printing it.

The script includes some commented-out lines related to printing information but are not executed.
After the script generates the CREATE LOGIN statements, it selects the contents of the #Command table, which holds the generated script.

This is the reason the login will get create in the secondary after the jobs run first in primary and then run in the secondary.