QOD 18th Nov

  • Moan, groan....

    Got this one wrong, as I thought it was a trick question.

    You don't remove the USER, as the answer says, you need to remove and recreate the LOGIN.

  • Something that I have used for several years and works quite well (never had an issue) is to use:

    sp_change_users_login 'report'

    in combination with

    sp_change_users_login 'Auto_Fix', 'userid'

  • I didn't like the question either.

    It says : 'create the same SQL Server authenticated user there (giving it the necessary permissions). '

    Especially the part between brackets is misleading. I was very suspicious. And got it right. This is a trick question.

    Maybe it is better to leave out questions that end with 'What is the most likely cause?

    '. This is always subject for interpretation.


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

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