The SET ENCRYPTION PASSWORD statement sets the default password and hint that will be used by the encryption and decryption functions. The password is not associated with authentication and is only used for data encryption and decryption.
SET ENCRYPTION PASSWORD 'Gre89Ea'
For more information, see SET ENCRYPTION PASSWORD in the SQL Reference topic in the
Information Center.