Post reply

Certificat encryption

  • February 13, 2006 at 3:35 am

    #152758

    Hi,

     

    I created certificat to encrypte my database password. It was work.

    But I don't see my certificat width "Microsoft SQL Server Management Studio"

    Where can I see my certificat ?

    Thanks.

    Kindest Regards,

    degrem_m
    Degremont

  • February 13, 2006 at 6:14 am

    #620396

    In my database >> Security >> Certificates , I see my certificate.

    I have possibility to refresh or  delete, but if I need know expiry date, it's impossible.

    How can I do for to get property certicate.

    For sample :

    CREATE CERTIFICATE CertificatCryptagePasswordMembership

    ENCRYPTION BY PASSWORD = 'Ukcdlmq_s_dg#qgdf@342'

    WITH SUBJECT = 'Cryptage password',

    START_DATE = '12/12/2005',

    EXPIRY_DATE = '12/12/2008';

    How can I do if I want expiry_date from my certificate ? Witch query or store procedure can I excute ?

     

     

    Kindest Regards,

    degrem_m
    Degremont

Viewing 2 posts - 1 through 1 (of 1 total)

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