Enabling column level encryption

• adish

  SSChasing Mays

  Points: 634

  More actions

  May 17, 2009 at 10:01 am

  #209525

  Hi

  We are looking to apply encryption to some columns of a database in SQL2005(SQL 2008 can also be used). Can somebody please guide me as to how this can be best accomplished?

  Also, would the use of UDTs make this process easier or more difficult? Not that it is necessary for us to use UDTs, but MSDN says that:

  "UDTs in SQL Server 2005 are well suited to the following:

  Date, time, currency, and extended numeric types

  Geospatial applications

  Encoded or encrypted data"

  Any help will be appreciated

  Thanks

  Adish

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736150

  More actions

  May 17, 2009 at 10:35 am

  #996037

  http://www.simple-talk.com/sql/sql-server-2005/encryption-without-the-confusion/