dbd_change_cert

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

The function sets, changes or removes encryption certificate. Encrypted database must be explicitly unlocked.

Parameter @cert contains certificate's thumbprint in hex. For example: '8a01043d222a856a43b685c1363ac3e122f0cfdf'.

Certificate must be available for SQL Server service and has private key.

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