ALTER CERTIFICATE

Alter a certificate in the database.

Syntax:
ALTER CERTIFICATE certificate REMOVE PRIVATE KEY

ALTER CERTIFICATE certificate WITH PRIVATE KEY ( private_key_spec [ ,... ] )

ALTER CERTIFICATE certificate WITH ACTIVE FOR BEGIN DIALOG = [ON | OFF]

private_key_spec:
FILE = 'path_to_private_key'
DECRYPTION BY PASSWORD = 'key_password'
ENCRYPTION BY PASSWORD = 'password'

Key:
key_password Password to decrypt the private key.
password Password to encrypt the private key of the certificate in the database.
REMOVE PRIVATE KEY The key should no longer be maintained inside the database.
ACTIVE FOR BEGIN_DIALOG
Make the cert available to the initiator of a Service Broker dialog conversation

If password complexity is enforced, the password must be > 8 chars and contain upper/lower case and numeric/ Non-alphanumeric characters.

The private key must correspond to the public key specified by certificate

Requires ALTER permission on the certificate.

Examples

ALTER CERTIFICATE MyCert1
WITH PRIVATE KEY (DECRYPTION BY PASSWORD = 'oldCertPassword3456gsf',
ENCRYPTION BY PASSWORD = 'newCertPassword$214kH');
GO


ALTER CERTIFICATE MyCert2
WITH PRIVATE KEY (ENCRYPTION BY PASSWORD = 'newKeyPassword64Jjh7',
DECRYPTION BY PASSWORD = 'oldKeyPassword706tt');
GO

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)