Encrypt & Decrypt table column ( ssn int, b_date)

• solomon.jernas

  Hall of Fame

  Points: 3680

  More actions

  July 14, 2011 at 12:54 am

  #389970

  HI

  Any any one could you help me..

  Encrypt the two column in table. in sql server 2005

  Example :

  Table Name: Accont

  colum : ssn int, bdate date

  need two column encryption with certifcate level..

  Help me

  Thaks

  Jerry

• winash

  SSChampion

  Points: 11446

  More actions

  July 14, 2011 at 1:11 am

  #1352596

  The links below have sample scripts on how to encrypt data in SQL Server 2005:

  http://blogs.msdn.com/b/lcris/archive/2005/06/09/simple-demo-for-how-to-encrypt-and-decrypt-a-table-column-in-sql-server-2005.aspx

  http://blogs.msdn.com/b/lcris/archive/2005/06/10/sql-server-2005-column-encryption-demo-part-2.aspx

  http://blogs.msdn.com/b/lcris/archive/2005/12/16/sql-server-2005-yet-another-column-encryption-demo-quot-clinic-quot.aspx