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

Symmetric Key Use Expand / Collapse
Author
Message
Posted Monday, April 7, 2014 9:34 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 5:30 PM
Points: 33,055, Visits: 15,167
Comments posted to this topic are about the item Symmetric Key Use






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1559342
Posted Monday, April 7, 2014 9:35 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:24 PM
Points: 1,672, Visits: 744
Nice question with a little bit of digging required to insure the correct answer.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1559343
Posted Monday, April 7, 2014 10:39 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Good one, Thanks Steve.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1559353
Posted Tuesday, April 8, 2014 12:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
Nice question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1559373
Posted Tuesday, April 8, 2014 5:14 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:05 PM
Points: 3,943, Visits: 2,957
Thank you for a very unambiguous question.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1559435
Posted Tuesday, April 8, 2014 7:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 1,826, Visits: 1,359
Thanks for the question Steve.



Everything is awesome!
Post #1559488
Posted Thursday, April 10, 2014 6:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:11 AM
Points: 2,381, Visits: 177
Thanks
Post #1560393
Posted Saturday, April 12, 2014 4:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, July 20, 2014 4:44 AM
Points: 1,124, Visits: 513
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/
Post #1561184
Posted Saturday, April 12, 2014 10:52 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 10:00 AM
Points: 8,551, Visits: 9,043
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
Post #1561223
Posted Thursday, April 24, 2014 12:44 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:39 AM
Points: 100, Visits: 546
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)
Post #1564826
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse