Post reply

Encrypt data in a column

  • August 29, 2006 at 8:03 am

    #169532

    Hello, I am looking into storing encrypted data in a column in my database.  What is the best way to have SQL Server 2005 encrypt a single column for me?  Is there a data type that does this automatically?  We can not change our existing application so the encrypting need to be done at the database level.  The calls to the database reside in the application.  Can encryption be done at the table/column level through an encryption data type?  Also once the data is encrypted, can searches be done on this encrypted data?  Thank you,

     

    David

    Best Regards,

    ~David

  • August 31, 2006 at 11:34 pm

    #657960

    You can read more about SQL Server 2005 security/encryption in this article:

    http://www.databasejournal.com/article.php/1503191

    Scroll down to 'SQL Server 2005 Security' and click on 'Encryption - Part 3'. There are some examples for you to try for yourself, which I find helpful.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply