Excuse my ignorance on this one. I have an SQL 2005 database and using Studio Express to look at the data etc. I have cleared all the data from the tables but cannot see how to reset the autonumbers in each table back to 1. Is there a simple way of doing this? With Access I use 'Compact and Repair' - is there something similar with Studio Express?
Many thanks, Rob