Search code examples
sqlasp.netsql-serverdatabasesql-server-2000

Is triple des Encryption /Decryption Support in sql server 2000?

For Example:

Here, Is this function EncryptByPassPharase() support in sql server 2000? If Not Then is there any function like that in sql server 2000? How Can I do same thing in sql server 2000? 

INSERT INTO  login_details(username,password) VALUES('smith2',EncryptByPassPhrase('12','XXX'))
Solution

  • No, the function EncryptByPassPharase() is not support for SQL Server < 2008. On microsoft doc has been detail about it. You can se more detail here ENCRYPTBYPASSPHRASE