INSERT INTO ENCRYPTED DATABASE

• VastSQL

  SSC-Dedicated

  Points: 36144

  More actions

  June 16, 2010 at 4:32 am

  #223899

  Hi Experts,

  How to insert into an encrypted database??

  I have encrypted a database but now they want to insert records into that table.

  I have deleted the original column after creating an encrypted column and datas into it..

  I have done the encryption like this

  http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx

  Please help

  TIA

• VastSQL

  SSC-Dedicated

  Points: 36144

  More actions

  June 16, 2010 at 5:09 am

  #1180864

  YA GOT IT

  Inserted data by

  USE EncryptTest

  GO

  OPEN SYMMETRIC KEY TestTableKey DECRYPTION

  BY CERTIFICATE EncryptTestCert

  INSERT INTO TestTable VALUES (6,

  ENCRYPTBYKEY(KEY_GUID('TestTableKey'),'SIX'))

  GO