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 and Certificate Creation date Expand / Collapse
Author
Message
Posted Friday, March 7, 2014 2:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 6, 2014 7:33 AM
Points: 11, Visits: 42
Is there a way to see the date and time a symmetric key or certificate was created?
Post #1548912
Posted Monday, March 10, 2014 2:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Execute following:

select * from sys.symmetric_keys

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1549137
Posted Monday, March 10, 2014 7:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 6, 2014 7:33 AM
Points: 11, Visits: 42
That did it. Thanks for your help.
Post #1549217
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse