A New SMK

  • Comments posted to this topic are about the item A New SMK

  • Nice easy question to end the week ....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Yay - I got it right.

    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

  • SQLRNNR (1/5/2012)


    Yay - I got it right.

    +1, but it was not obvious.

    I mark this one as 50 percent educated guess, 50 percent luck.

  • But I forgort to thank Steve for the challenge -- so here we go: thanks, Steve!

  • Thank you Steve, got me thinking 🙂

    M&M

  • Thanks.

    I was fairly sure of my answer... but admit to doubting myself just a bit.

    Nice to see I got it right.

  • Good question.

    Needed more thought than usual to get the answer - my first reaction was that it's created by magic when sql server is installed, but I could see that was wrong because that wasn't one of the options, so I had to think what would trigger its creation.

    Tom

  • very good question!!!

    I learned more thing!!!!!!

    thanks Steve!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • slightly crafty steve, but I got it.

    Interestingly, MS advise one of the first things you should do on installing an instance is backup the service master key, and this indeed you can do even though encryption has not been activated. So what in fact are we backing up at that point?

    ---------------------------------------------------------------------

  • I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.

  • rothj (1/6/2012)


    I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.

    I should have had that as an option. 😉

  • Steve Jones - SSC Editor (1/6/2012)


    rothj (1/6/2012)


    I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.

    I should have had that as an option. 😉

    I would likely have fallen for that trap also! Tks Steve

  • Steve Jones - SSC Editor (1/6/2012)


    rothj (1/6/2012)


    I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.

    I should have had that as an option. 😉

    You would have tripped me up with this, for sure. As it stands, I did answer this question correctly.

    Thanks and have a good weekend,

    Matt

  • Three in a row wrong!!! :crying:

Viewing 15 posts - 1 through 15 (of 20 total)

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