Can we protect the password used encryption of data using Symmetric key

• mail2gauravbehl

  Grasshopper

  Points: 11

  More actions

  December 28, 2009 at 2:31 am

  #218986

  hi

  i am trying to encrypt data in a few columns using symmetric key which is password protected.

  I do not want to write the password in plain text in either a Stored procedure or UDF while creating or opening the key.

  Please can you suggest how can i protect the password(keep it in memory or something)

  Thanks

• Mike01

  SSChampion

  Points: 11395

  More actions

  December 28, 2009 at 10:11 am

  #1096752

  I used a symmetric key and a certificate to get around storing the password anywhere. You can also encrypt the stored procedure, but you better have a backup of it, since once it's encrypted you can't get it back.

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/