EncryptByCert(Cert_ID('AAA'), SSN)

• Jay Byoun

  SSC-Addicted

  Points: 428

  More actions

  September 10, 2013 at 1:46 pm

  #277844

  I was updating a table with encrypted data using EncryptByCert(Cert_ID('XXX'), YYY)..

  update command ran well for 250,000 rows with no error, but 50,000 of them were updated with NULL value even the input data was not null and the length was less than 117.. of course I re-ran the update statement for the 50,000 and they were updated with proper encrypted value..

  Has anyone had this kind of issue?