Post reply

Export Logins - sp_help_revlogin

  • September 25, 2014 at 3:21 pm

    #291102

    We are trying to find a way to execute the sp_help_revlogin stored procedure, name the output as Logins.sql, and export to a folder on another server. I have googled, and searched this forum, but have not figured out a good way to do this with code. Any ideas or feedback will be appreciated.

    Thanks

  • September 25, 2014 at 6:14 pm

    #1748369

    Hey,

    If you save the results to file (a little button on the tool bar before you execute the the SP), then just copy the file to where you want it, copy and paste the contents onto the server you want to create the logins on and your sorted.

    Regards,D>

  • September 26, 2014 at 7:52 am

    #1748506

    Thanks for the reply. We can do this manually, but are looking for a way to automate the process. We copy our production backup over to a test server each week and would like to setup some sort of job to copy over the logins and sync them automatically.

  • October 15, 2014 at 1:01 pm

    #1752664

    We figured this out using xp_cmdshell xcopy and renaming the backup files once they were copied over. Thanks for the feedback on this.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply