Hi All,
Can any body tell me how to reset AutoNumber, i.e. identity value starting from
1?
I'd like to clean all the testing data from SQL database and have the identity
value
start from 1. I used to generate script and recreate tables. I think there
should be
a way to do this without recreating the table. Any body knows how?
Thanks!
Eva
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
