Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 12, 2013 2:28 PM
Points: 12, Visits: 159
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