I came across a problem to update a varchar(MAX) field.
I use a varchar(MAX) field to save transaction data. It is required to update that field once a while by removing sensetive infromation from that field.
I use update statment to do that and everything looks fine. But, if I back up the database and open it using notepad I can see those sensetive strings.
It looks to me that update statement allocates another space to save the new data and does not zero fillout the space used by old data. It is kind of like deleting files from OS.
What can I do in this case?
View Complete Post