Find signed procedures, functions, triggers, assemblies and by which certificates / asymmetric keys
7
votes
1
answer
5644
views
I have created a few Certificates (via CREATE CERTIFICATE ) and Asymmetric Keys (via CREATE ASYMMETRIC KEY ) and used them to sign and counter-sign various SQL modules:
- Stored Procedures
- User-Defined Functions (UDFs)
- Triggers
- Assemblies
Signing was done via ADD SIGNATURE .
But now I need to find which Certificates and/or Asymmetric Keys have been used to sign which particular modules.
Asked by Solomon Rutzky
(70048 rep)
Jan 22, 2016, 07:48 PM
Last activity: Oct 12, 2023, 10:37 AM
Last activity: Oct 12, 2023, 10:37 AM