I am having an issue with the way SQL server deletes data. I am
trying to delete data from the DB and have it completetly gone.
Here is what I did
1. added a table with a row of image data
2. inserted a text file into the row with a string i could search
for.
3. opened the mdf file up in a hex editor and found the data
4. deleted the row in sql server
5. reopened the file in the hex editor and the data was still there
no matter what i do i cant get rid of the data from the file. i have
tried shrinkdatabase, update and updatetext to overwrite the data and
nothing works.
anyone know how to REALLY delete things from an SQL DB?
Thanks