Which stored procedure should you use to export the logins?

You plan to migrate an on-premises Microsoft SQL Server database to a virtual machine hosted in Microsoft Azure.
You need to ensure that each user of the database has a unique login after the migration is complete.
Which stored procedure should you use to export the logins?
A. sp_change_users_login
B. xp_logininfo
C. sp_help_revlogin
D. sp_helplogins

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.