I am trying to transfer the logins from the production instance to the test instance after a refresh activity for restoring the DB's regarding the same.
From the output of sp_help_revlogin on prod DB, ran the output from earlier onto the staging to map the logins, but for most of them I got below errors:
Msg 15433, Level 16, State 1, Line 12
Supplied parameter sid is in use.
However after confirming the same from logins folder, I can see those logins created.
Is this Ok behaviour or is there something to make sure, created login works perfectly fine.
Please suggest, thanks!
Aucun commentaire:
Enregistrer un commentaire