sp_help_revlogin missing

Question

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.

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

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

frederico_fonseca SSCoach Points: 16014 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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 · Answer 4

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