Home Forums SQL Server 2005 Administering where my Master Key and certificate is stored. RE: where my Master Key and certificate is stored.

  • August 24, 2009 at 5:09 am

    #1043533

    luckysql.kinda (8/24/2009)

    I want to understand today where my Master Key and certificate is stored. Can anyone help

    SELECT * FROM SYSOBJECTS WHERE name LIKE '%TestCertificate%'

    -- Could not find any value even though the certificate is visible in the database-->security-->Certificate

    -LK

    This article should give you the background which will help you more.

    http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]