Encrypting the data

• samsql

  Hall of Fame

  Points: 3044

  More actions

  September 29, 2009 at 4:29 am

  #226679

  hi all,

  i want to encrypt the data from a column

  m using sqlserver 2008

  i wanna know how to encryt the data while insert it into the table

  Eg if some one enters the Password it should get insert in the table in the encrypted form

• WI-DBA

  SSCrazy

  Points: 2110

  More actions

  September 29, 2009 at 10:13 am

  #1059584

  This might help, its not particularly difficult to setup - varbinary storage..

  http://msdn.microsoft.com/en-us/library/cc278098.aspx

  also, open SSMS, F1, search for this :encryption [SQL Server], functions

  Cheers
  http://twitter.com/widba
  http://widba.blogspot.com/