where my Master Key and certificate is stored.

Question

Post reply

where my Master Key and certificate is stored.

luckysql.kinda

SSCertifiable

Points: 7816
More actions
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

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

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

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

Suresh B.

SSC-Insane

Points: 22986

August 24, 2009 at 4:55 am

#1043531

select * from sys.certificates

Silverfox SSC-Insane Points: 23150 More actions · Answer 2

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]

luckysql.kinda SSCertifiable Points: 7816 More actions · Answer 3

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

-LK

Suresh B. SSC-Insane Points: 22986 More actions · Answer 4

Database master key:

select * from sys.symmetric_keys

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

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/