In the DOD arena there are times that data needs to 'disappear'. I was asked by a customer yesterday what options were available for scrubbing of data. I offered the ability to delete records in audit trails and the asked a question I had never even considered. Once Remedy issues the Delete command...and commits the transaction it is deleted out of the table...but what can be done to ensure the data is gone and not just having the pointer to the data removed. Those in government are familiar with the 'military wipe' type of cleaning utilities. We are running SQL Server 2000, are there DB commands that I can run to perform an online compress or something like that? TYIA
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
