Master Keys

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3994

    thanks for the question - cheers

  • Revenant

    SSC-Forever

    Points: 42467

    A great one before the coming long weekend - thanks!

  • Haining

    SSCrazy

    Points: 2118

    Like the question!

    A real good one.

  • This was removed by the editor as SPAM

  • Cliff Jones

    SSChampion

    Points: 10517

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

  • sestell1

    SSChampion

    Points: 10230

    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.

  • Peter Maloof

    SSCommitted

    Points: 1733

    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

  • kapfundestanley

    SSCertifiable

    Points: 5632

    Thank you all guys.

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

  • Hardy21

    SSCrazy Eights

    Points: 9708

    Nice one...

    Thanks

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks for the question.

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

  • Britt Cluff

    SSCertifiable

    Points: 5083

    Good straightforward question. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • Neha05

    Default port

    Points: 1494

    Thanks for the question!

  • Dineshbabu

    Hall of Fame

    Points: 3220

    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.

    "http://technet.microsoft.com/en-us/library/ms174382(v=sql.105).aspx"

    Can u pls xplain?

    Thanks..

    --
    Dineshbabu
    Desire to learn new things..

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

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