Master Keys

  • thanks for the question - cheers

  • A great one before the coming long weekend - thanks!

  • Like the question!

    A real good one.

  • This was removed by the editor as SPAM

  • Great question. Like many others I didn't really know but made the right assumption.

  • Steve Cullen (5/25/2012)

    These sorts of questions always make me wonder if what I think I know is correct.

    Why would there more than one "master"? Seems like a simple question, but what if . . .

    Yea, me too. I did a bunch of research before answering as I was sure it was a trick question of some sort.

  • Nice question. I was pretty sure the answer was 1, even after reading this in Books Online:

    It is only necessary to create the master key once per database.

    I think that could be phrased a bit better.

    Peter MaloofServing Data

  • Thank you all guys.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • Nice one...


  • Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    I have given a name to my pain...MCM SQL Server, MVP
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Good straightforward question. Thanks for submitting.

  • Thanks for the question!

  • SQLRNNR (5/29/2012)

    Thanks for the question.

    I tried to create more than one but it is not possible, so i answered 1 and got it correct..

    Even after reading the reference , I'm unable to understand the real usage of this key.


    Can u pls xplain?


    Desire to learn new things..

Viewing 13 posts - 16 through 27 (of 27 total)

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