• Very good.

    I was searching for someone that explain the why in sql server exists a "herarchy" for crypt data...

    After you give the example of encryption using pass phrase and encryption using objects for this, i understood "the why".

    And it is really...

    But how Pinal dave too quote in your blog if user has access and permissions to database, then the crypt dont useful...

    But, if the problem is database files to be compromised, the cript is useful, and the methods for protect the password for encryption/decryption is very good in SQL Server...

    Thanks!:-D