posted 13 years ago
Hi,
There is an existing system in my company, where we are having 40 blob fields in a table.
Now we have decided to implement RSA, and we are now storing encrypted values.
When inserting Database gives error that it can only store 8000 bytes per row..
Of course now since encryption implementation is necessary and table design, though poor, cannot be changed..
I was thinking of Data Compression before inserting Data into the DB so that it can be stored within 8000 bytes.
Just for knowledge, we are using SQL Server 2000
Can Someone Help??