dbd_change_cert @cert varchar(40) [, @remove=1 ]

This function sets, changes or removes the encryption certificate. An encrypted database must be explicitly unlocked.

The parameter @cert contains the certificate's thumbprint in hex. For example: '8a01043d222a856a43b685c1363ac3e122f0cfdf'.

The certificate must be available for SQL Server service and have private key.

To remove encryption with the certificate call exec dbd_change_cert @remove=1