Column encryption and decription........

• Sen1

  SSC Veteran

  Points: 215

  More actions

  March 26, 2013 at 8:34 am

  #291388

  Hello experts,

  I need to encrypt 4 col. in sql server 2008 and decrypt again. Do I have to do one column at a time or all together, if somebody give me more info with steps I would really appreciate.

• Steven Willis

  SSCrazy Eights

  Points: 9893

  More actions

  March 26, 2013 at 8:49 am

  #1600848

  Sen1 (3/26/2013)

  ---

  Hello experts,

  I need to encrypt 4 col. in sql server 2008 and decrypt again. Do I have to do one column at a time or all together, if somebody give me more info with steps I would really appreciate.

  Perhaps these articles will get you started:

  Using s symmetric key[/url]

  Decryption and CASTing[/url]