Table column encryption

• gabbyndu

  SSC Enthusiast

  Points: 148

  More actions

  January 29, 2014 at 1:22 am

  #303839

  Please how do i encrypt/decrypt column in a table so that the records will be useless for who ever wants to have access to it.

  thanks

• DuncEduardo

  SSCarpal Tunnel

  Points: 4410

  More actions

  January 30, 2014 at 9:23 am

  #1684730

  This is quite a good starting point, although BOL does have some decent guides on this subject.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 3, 2014 at 1:46 pm

  #1693689

  gabbyndu (1/29/2014)

  ---

  Please how do i encrypt/decrypt column in a table so that the records will be useless for who ever wants to have access to it.

  thanks

  Check this ..

  http://technet.microsoft.com/en-us/library/ms179331(v=sql.90).aspx

  http://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/

  --

  SQLBuddy