dbd_change_cert
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