Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

A New SMK Expand / Collapse
Author
Message
Posted Thursday, January 5, 2012 9:01 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
Comments posted to this topic are about the item A New SMK






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1231241
Posted Thursday, January 5, 2012 9:02 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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

Before posting a performance problem please read
Post #1231242
Posted Thursday, January 5, 2012 10:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 5:04 PM
Points: 18,055, Visits: 16,086
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
Post #1231255
Posted Friday, January 6, 2012 1:37 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
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.
Post #1231287
Posted Friday, January 6, 2012 1:38 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
But I forgort to thank Steve for the challenge -- so here we go: thanks, Steve!
Post #1231288
Posted Friday, January 6, 2012 3:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
Thank you Steve, got me thinking :)

Mohammed Moinudheen
Post #1231322
Posted Friday, January 6, 2012 3:37 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, December 6, 2013 7:23 AM
Points: 614, Visits: 57
Thanks.
I was fairly sure of my answer... but admit to doubting myself just a bit.
Nice to see I got it right.



Post #1231342
Posted Friday, January 6, 2012 4:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:11 PM
Points: 7,920, Visits: 9,646
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
Post #1231385
Posted Friday, January 6, 2012 5:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 11:08 AM
Points: 1,262, Visits: 13,557
very good question!!!

I learned more thing!!!!!!

thanks Steve!!!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1231393
Posted Friday, January 6, 2012 6:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 5,888, Visits: 13,060
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?


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

Post #1231403
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse