I wanted to check the expiration date of certificates used for SQL database mirroring.
Here is how you do it.

Just open SQL Management studio and make a new query on the master DB:

select * from sys.certificates

In the results you can check the expiration date and time in the column expiry_date.

Remember to renew the certificates in time

Tags: Authenti- cation, Availablity

This entry was posted on Monday, May 25th, 2009 at 2:31 pm and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.