sp_help_revlogin missing

• Mia G

  Old Hand

  Points: 374

  More actions

  January 21, 2019 at 4:37 pm

  #381253

  We have a 2017 install that was set up as windows auth. We recently decided to use mixed mode instead for various reasons. I created a sql login that I would like to script out but have found that both sp_help_revlogin and sp_hexadecimal are missing from the master db. I cannot find any information explaining why this would be. The only suspicion I have at this point is perhaps they were not created since windows only was selected at setup. Has anyone else had this happen before or know why it occurred? I was going to script out these missing procs from another 2017 server if I cannot find a better solution.

• frederico_fonseca

  SSCoach

  Points: 16225

  More actions

  January 21, 2019 at 4:51 pm

  #2019569

  look at https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server
  contains code for both functions.

  you may also wish to look at https://dbatools.io/ for other tools to do this (and a lot more)

• Mia G

  Old Hand

  Points: 374

  More actions

  January 21, 2019 at 5:10 pm

  #2019570

  Thanks. I do have the scripts needed to create the missing procs already. The main concern I have is why they are missing in the first place. Am I to assume that I should not expect for the procs to be created automatically?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  January 21, 2019 at 5:22 pm

  #2019571

  Mia G - Monday, January 21, 2019 5:10 PM

  Am I to assume that I should not expect for the procs to be created automatically?

  That would be correct. They aren't missing - you need to run the scripts to create them.

  Sue

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  January 22, 2019 at 2:18 am

  #2019598

  As Sue says, they're not included as part of the install: you have to add them if you want them.