Export (0) Print Expand All 2 out of 4 rated this helpful - Rate
this topic  SQL Server Certificates and Asymmetric Keys
Certificates and asymmetric keys are both ways to use asymmetric
encryption. Certificates are often used as containers for
asymmetric keys because they can contain more information such
as expiry dates and issuers. There is no difference between the
two mechanisms for the cryptographic algorithm, and no
difference in strength given the same key length. Generally, you
use a certificate to encrypt other types of encryption keys in a
database, or to sign code modules.  Certificates and asymmetric
keys can decrypt data that the other encrypts. Generally, you
use asymmetric encryption to encrypt a symmetric key for storage
in a database.  A public key does not have a particular format
like a certificate would have, and you cannot export it to a
file.  Note Note  SQL Server contains features that enable you
to create and manage certificates and keys for use with the
server and database. SQL Ser