Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Alter Certificate


Alter Certificate

Author
Message
Ed Wagner
Ed Wagner
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10324 Visits: 9600
Good question - thanks.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Thomas Abraham
Thomas Abraham
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2347 Visits: 2254
Raghavendra Mudugal (9/12/2013)
Interesting one, Steve. Thank you for the post.

(I am on fire..... never got the 4 questions correct in a row before and this week I did... with just logical analysis and no execution. I am very excited about tomorrow's qtod and hoping to get it correct... :-D if i did.... man... all 5 five FIVE!!!! :coolSmile


Really Raghu, I was disappointed in your post. I expected you to be excited about having got 100 questions right, and looking forward to closing out the week having got all 101 questions correct. ;-)

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Dana Medley
Dana Medley
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2316 Visits: 1691
Thanks for the question!



Everything is awesome!
Raghavendra Mudugal
Raghavendra Mudugal
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1688 Visits: 2958
Thomas Abraham (9/12/2013)
Raghavendra Mudugal (9/12/2013)
Interesting one, Steve. Thank you for the post.

(I am on fire..... never got the 4 questions correct in a row before and this week I did... with just logical analysis and no execution. I am very excited about tomorrow's qtod and hoping to get it correct... :-D if i did.... man... all 5 five FIVE!!!! :coolSmile


Really Raghu, I was disappointed in your post. I expected you to be excited about having got 100 questions right, and looking forward to closing out the week having got all 101 questions correct. ;-)


Thank you for the support, Thomas, and I am sorry that I have disappointed you. (I wish I had that much of knowledge where I can get 100 straight correct... but one day I will... :-) )

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
TomThomson
TomThomson
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10761 Visits: 12019
Nice question, but it seems odd to refer to the SQL 2005 version of the BOL page for command, when there are perfectly good versions for the three releases currently in full support.

Tom

Hugo Kornelis
Hugo Kornelis
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8337 Visits: 11580
Raghavendra Mudugal (9/12/2013)
Thomas Abraham (9/12/2013)
Raghavendra Mudugal (9/12/2013)
Interesting one, Steve. Thank you for the post.

(I am on fire..... never got the 4 questions correct in a row before and this week I did... with just logical analysis and no execution. I am very excited about tomorrow's qtod and hoping to get it correct... :-D if i did.... man... all 5 five FIVE!!!! :coolSmile


Really Raghu, I was disappointed in your post. I expected you to be excited about having got 100 questions right, and looking forward to closing out the week having got all 101 questions correct. ;-)


Thank you for the support, Thomas, and I am sorry that I have disappointed you. (I wish I had that much of knowledge where I can get 100 straight correct... but one day I will... :-) )

I think Thomas wrote that comment in reference to your signature on these forums... w00t


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
sknox
sknox
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2036 Visits: 2712
L' Eomot Inversé (9/12/2013)
Nice question, but it seems odd to refer to the SQL 2005 version of the BOL page for command, when there are perfectly good versions for the three releases currently in full support.


True, but consider this: the certificate system was new in 2005, so the question is relevant to that version and future versions. Also, the only change in substance is for the 2012 version:
"The WITH PRIVATE KEY option is not available in a contained database."

They also clarified the statement "This password is subject to password complexity policy. For more information, see Password Policy." (2005 version)
to "[P]assword must meet the Windows password policy requirements of the computer that is running the instance of SQL Server. For more information, see Password Policy." (2008, 2008R2, and 2012 version)

There are a few other formatting/layout changes but that's it. Even the examples are the same, down to the very character.
JAZZ Master
JAZZ Master
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1395 Visits: 857
Hugo Kornelis (9/12/2013)
Raghavendra Mudugal (9/12/2013)
Thomas Abraham (9/12/2013)
Raghavendra Mudugal (9/12/2013)
Interesting one, Steve. Thank you for the post.

(I am on fire..... never got the 4 questions correct in a row before and this week I did... with just logical analysis and no execution. I am very excited about tomorrow's qtod and hoping to get it correct... :-D if i did.... man... all 5 five FIVE!!!! :coolSmile


Really Raghu, I was disappointed in your post. I expected you to be excited about having got 100 questions right, and looking forward to closing out the week having got all 101 questions correct. ;-)


Thank you for the support, Thomas, and I am sorry that I have disappointed you. (I wish I had that much of knowledge where I can get 100 straight correct... but one day I will... :-) )

I think Thomas wrote that comment in reference to your signature on these forums... w00t

Y'all are too funny! Had a good laugh today. Hehe
Revenant
Revenant
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5815 Visits: 4718
sknox (9/12/2013)
L' Eomot Inversé (9/12/2013)
Nice question, but it seems odd to refer to the SQL 2005 version of the BOL page for command, when there are perfectly good versions for the three releases currently in full support.


True, but consider this: the certificate system was new in 2005, so the question is relevant to that version and future versions. Also, the only change in substance is for the 2012 version:
"The WITH PRIVATE KEY option is not available in a contained database."

They also clarified the statement "This password is subject to password complexity policy. For more information, see Password Policy." (2005 version)
to "[P]assword must meet the Windows password policy requirements of the computer that is running the instance of SQL Server. For more information, see Password Policy." (2008, 2008R2, and 2012 version)

There are a few other formatting/layout changes but that's it. Even the examples are the same, down to the very character.

It may be my setting of BoL but I am getting 2012 by default.
sqlnaive
sqlnaive
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3691 Visits: 2774
Simple and good question. :-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search