DECRYPTBYPASSPHRASE returns NULL if it receives the wrong passphrase or the wrong authenticator information.ĭECRYPTBYPASSPHRASE uses the passphrase to generate a decryption key. RemarksĭECRYPTBYPASSPHRASE requires no permissions for its execution. Varbinary, with a maximum size of 8,000 bytes.

authenticator has a sysname data variable containing data used as the basis for the generation of the authenticators.

The data used as the basis for the generation of the authenticator. Is has a value of 1 if the encryption process used an authenticator. add_authenticator has an int data variable indicating whether the original encryption process included, and encrypted, an authenticator together with the plaintext. add_authenticator has a value of 1 if the encryption process used an authenticator. Indicates whether the original encryption process included, and encrypted, an authenticator together with the plaintext. The variable has a maximum size of 8,000 bytes. ciphertext has a varbinary data variable of type varbinary containing data encrypted with the key. The string of data encrypted with the key. The passphrase used to generate the decryption variable of type char, nchar, nvarchar, or varchar containing the passphrase used to generate the decryption key. To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

Sqlserver decode