Post reply

where my Master Key and certificate is stored.

  • August 24, 2009 at 4:45 am

    #134392

    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

  • August 24, 2009 at 4:55 am

    #1043531

    select * from sys.certificates

  • 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]

  • August 24, 2009 at 5:30 am

    #1043540

    Thanks suresh. Can you also tell me where I can find the service master key and database master key?

    -LK

  • August 24, 2009 at 7:11 am

    #1043601

    Database master key:

    select * from sys.symmetric_keys

  • July 16, 2014 at 10:14 am

    #1729925

    Suresh B. (8/24/2009)

    Database master key:

    select * from sys.symmetric_keys

    ok how can I delete the mater and subordinates?

    Thanks.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 6 posts - 1 through 5 (of 5 total)

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