Data Encryption

• Emilio Baez

  SSC Enthusiast

  Points: 138

  More actions

  September 23, 2005 at 12:33 pm

  #87841

  Hi guys:

   I have an asp application that asks the users for their SSN. I like to know a way of encrypting this value when is written into the database and right before is extracted from the database for comparison purposes. I tought of creating a stored procedure to do the insert and the extraction, but I do not know how to do the encryption part.

  I will appracitae any help on this.

  Thanks

  ---

  Kindest Regards,

  Emilio

• Roy Rogers

  SSCertifiable

  Points: 7712

  More actions

  September 23, 2005 at 12:38 pm

  #592719

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=32&messageid=123118#bm200209

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=208789#bm208812

  Search for encrypt undocumented you will find more links

  Regards,
  gova

• Emilio Baez

  SSC Enthusiast

  Points: 138

  More actions

  September 23, 2005 at 12:52 pm

  #592727

  thanks govvin, those two links are pretty helpful

  ---

  Kindest Regards,

  Emilio