RE: How to completely delete any trace of data from a SQL2000 data

Didn't have to do anything fancy to do the verification, actually. Using a
text editor robust enough to allow me to view the large data files (I've use
d
TextPad, UltraEdit 32, and Boxer on various occasions), I did the following:

1. Opened the file.
2. Used the Find function to search for marker text strings I placed in the
document.
3. Found the marker text strings. These were embedded in the full text of
the document, which was present in its entirety.

-B

"Absar Ahmad" wrote:

> How are you verifying that ' Text of data file still contains the text of 
the
> document'?
>
> "BAG" wrote:
> 

Are you opening 'data files' of the SQL Server Database?

I am sorry if my question looks stupid.

"BAG" wrote:

> Didn't have to do anything fancy to do the verification, actually. Using a
> text editor robust enough to allow me to view the large data files (I've u
sed
> TextPad, UltraEdit 32, and Boxer on various occasions), I did the followin
g:
>
> 1. Opened the file.
> 2. Used the Find function to search for marker text strings I placed in th
e
> document.
> 3. Found the marker text strings. These were embedded in the full text of
> the document, which was present in its entirety.
>
> -B
>
> "Absar Ahmad" wrote:
> 

Exactly. In this case, the DB in question just has one data file (.mdf) and
one log file
(.ldf). I found the text of the document in the .mdf even after I confirmed
it was deleted in the tables.

-B

"Absar Ahmad" wrote:

> Are you opening 'data files' of the SQL Server Database?
>
> I am sorry if my question looks stupid.
>
> "BAG" wrote:
>