Home Forums SQL Server 2008 T-SQL (SS2K8) Encrypt SSN Example (TDE) RE: Encrypt SSN Example (TDE)

  • July 15, 2014 at 1:23 pm

    #1729610

    GilaMonster (7/15/2014)

    There's nothing about the column which makes it encrypted. You would need to encrypt the values when you insert (eg with EncryptByKey) and decrypt the values when you select then (eg with DecryptByKey)

    So this needs to be done via .NET, etc or what?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/