Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Johnyalm
Starting Member
49 Posts |
 Posted - 2001-05-02 : 14:44:17
|
| I would like to reset the IDENTITY to 1 in certian tables now and then (during development). I read data from external source, and that data har reference to other tables hardcoded. I would like to DELETE all records with a script and then set the IDENTITY seed to 1 again for the table that now are empty, as well in the same script - any solution to suggest?Johny Almwww.mirrorgate.comwww.mirrorgate.com |
|
|
|
|
|
Resetting table IDENTITY in MSSQL