I have a SQL Server 2000 DB that has numerous tables that I would like to reset back to how they would have been just after creation( i.e. blank fields throughout) I’d like a number 1 to appear in the first index column when a new record is added. At the moment when I add a new record number 14 appears but i cannot access any of the records prior to that to delete them. How can I wipe out all of the existing records from thast table whilst still keeping the table intact ?
Many thanks for your help
