Removing Records

I restored a database from SQL2000 to SQL2008. I would like to know if there is an easier way to delete all records but keep all the tables without having to do this one table at a time and deleting each record at a time.

i sent in a support request and was given instructions to download and use dasp_cleandb.bak to restore my database. what this did was not only remove the records, but all the tables too and left only sys. tables, not my ado tables which i need.

 

Is this any use to you?
http://www.eggheadcafe.com/tutorial...10-143fbceffe97/sql-server--delete-recor.aspx

 

...That's a good one Joe.
AEII...They must have misunderstood your request, I can't imagine any of them would have suggested that to remove records.
All the best,
Mark