Symmetric Key Use

Question

Post reply

Symmetric Key Use

Steve Jones - SSC Editor

SSC Guru

Points: 736291
More actions
April 7, 2014 at 9:34 pm

#75689

Comments posted to this topic are about the item Symmetric Key Use

Viewing 9 posts - 1 through 8 (of 8 total)

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Nice question with a little bit of digging required to insure the correct answer.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Good one, Thanks Steve.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Thank you for a very unambiguous question.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

Thanks for the question Steve.

Everything is awesome!

Hany Helmy SSChampion Points: 13921 More actions · Answer 6

Good question! had to do some R&D to find out the correct answer. And here is a good reference for the same subject:

http://www.sqlservercentral.com/blogs/steve_jones/2013/12/16/symmetric-keys/

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Nice simple question. But I wonder if the 35% of responses from people who want to deallocate teh key think that the key is some kind of cursor?

Tom

deepforest SSCommitted Points: 1780 More actions · Answer 8

I hate to be picky, but:

if exists (select * from sys.openkeys where key_name={key_name})

close symmetric key {key_name}

If you try to close it twice by accident, you get an error:

(The key {key_name} is not open. Please open the key before using it)