Cryptographic Functions (Transact-SQL)

The following functions support encryption, decryption, digital signing, and the validation of digital signatures.

Symmetric Encryption and Decryption

Asymmetric Encryption and Decryption

Signing and Signature Verification

Symmetric Decryption with Automatic Key Handling

See Also

Reference

Functions (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
Security Catalog Views (Transact-SQL)

Other Resources

Encryption Hierarchy
Permissions Hierarchy

Help and Information

Getting SQL Server 2005 Assistance