Module Signing Info (Reference)

Module Signing, signature, certificate, asymmetric key, SQL Server, T-SQL, TSQL, SQLCLR, SQL# 2024-11-14 7-5

Module Signing Info

Home Concepts Answers Reference Microsoft Connect Contact

Module Signing, signature, certificate, asymmetric key, SQL Server, T-SQL, TSQL, SQLCLR, SQL#

— Reference —

Category	Commands & Functions	Tables & Views
General	ADD SIGNATURE DROP SIGNATURE IS_OBJECTSIGNED sys.fn_check_object_signatures	sys.crypt_properties
Asymmetric Keys	CREATE ASYMMETRIC KEY ALTER ASYMMETRIC KEY DROP ASYMMETRIC KEY ASYMKEY_ID SIGNBYASYMKEY VERIFYSIGNEDBYASYMKEY ENCRYPTBYASYMKEY DECRYPTBYASYMKEY ASYMKEYPROPERTY	sys.asymmetric_keys
Certificates	CREATE CERTIFICATE ALTER CERTIFICATE DROP CERTIFICATE BACKUP CERTIFICATE CERTENCODED (starting in 2012) CERTPRIVATEKEY (starting in 2012) CERT_ID SIGNBYCERT VERIFYSIGNEDBYCERT ENCRYPTBYCERT DECRYPTBYCERT CERTPROPERTY	sys.certificates
Master Keys	CREATE MASTER KEY OPEN MASTER KEY CLOSE MASTER KEY ALTER MASTER KEY DROP MASTER KEY BACKUP MASTER KEY RESTORE MASTER KEY	sys.symmetric_keys sys.openkeys sys.key_encryptions

Windows / .NET	Sn.exe (Strong Name Tool) ILDasm.exe (IL Disassembler) MakeCert (Make Certificate) CertUtil (Certificate Utility) Pvk2Pfx.exe (PVK file to PFX file) SignTool.exe (Sign Tool) New-SelfSignedCertificate

Module Signing, SQL Server, certificate, signature, certificate, asymmetric key, T-SQL, TSQL, SQLCLR, SQL# 2024-11-14 7-5