Recently I was tasked with the responsibility of purging database from one of our SQL 2000 databases. One of the test cases is to use a copy of a database that is a small production database and delete all of the data contained within. After the delete is executed then I can review the data tables and see what is left over or was skipped after the delete script runs. Looking at the properties of hundreds of tables in Enterprise Manager seemed pretty tedious.
After a quick query to Bing I was able to find a decent reference where someone had already done the work for me.