January 5, 2012 at 9:02 pm
January 5, 2012 at 10:24 pm
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
January 6, 2012 at 1:37 am
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.
January 6, 2012 at 1:38 am
But I forgort to thank Steve for the challenge -- so here we go: thanks, Steve!
January 6, 2012 at 3:03 am
Thank you Steve, got me thinking 🙂
M&M
January 6, 2012 at 3:37 am
Thanks.
I was fairly sure of my answer... but admit to doubting myself just a bit.
Nice to see I got it right.
January 6, 2012 at 4:59 am
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
January 6, 2012 at 5:36 am
very good question!!!
I learned more thing!!!!!!
thanks Steve!!!
January 6, 2012 at 6:06 am
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?
---------------------------------------------------------------------
January 6, 2012 at 6:45 am
I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.
January 6, 2012 at 8:40 am
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. 😉
January 6, 2012 at 9:34 am
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
January 6, 2012 at 1:00 pm
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
January 6, 2012 at 5:14 pm
Three in a row wrong!!! :crying:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply