Post reply

Master Keys

  • May 25, 2012 at 9:18 am

    #1493232

    thanks for the question - cheers

  • May 25, 2012 at 9:41 am

    #1493252

    A great one before the coming long weekend - thanks!

  • May 25, 2012 at 10:45 am

    #1493293

    Like the question!

    A real good one.

  • May 25, 2012 at 12:07 pm

    This was removed by the editor as SPAM

  • May 25, 2012 at 12:27 pm

    #1493335

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

  • May 25, 2012 at 2:11 pm

    #1493376

    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.

  • May 26, 2012 at 5:16 pm

    #1493543

    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

  • May 27, 2012 at 9:01 am

    #1493594

    Thank you all guys.

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

  • May 28, 2012 at 12:40 am

    #1493643

    Nice one...

    Thanks

  • May 29, 2012 at 10:39 am

    #1494286

    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

  • June 4, 2012 at 7:44 pm

    #1496844

    Good straightforward question. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • August 9, 2012 at 8:57 am

    #1523852

    Thanks for the question!

  • January 9, 2013 at 4:05 am

    #1575144

    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 27 (of 27 total)

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