Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

EncryptByCert(Cert_ID('AAA'), SSN) Expand / Collapse
Posted Tuesday, September 10, 2013 1:46 PM


Group: General Forum Members
Last Login: Friday, October 16, 2015 12:44 PM
Points: 12, Visits: 162
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?

Post #1493347
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse