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 |
|
DataBasics101
Starting Member
2 Posts |
 Posted - 2007-03-12 : 11:53:32
|
| I'm using an Access app that feeds into an SQL database for order tracking. I've cleaned out all of the tables in SQL to have a fresh start but somehow everytime a new order is entered the next order ID number generated is still feeding from the old database and not starting at 1. Does anyone have some ideas on where I should be looking to find this old data? I've wiped every table that had orders or histoy data, but I can't seem to find where this starting order number is hiding(and updating). Thanks |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-12 : 11:59:39
|
| I guess this OrderID is an identity column. If you have used, DELETE command to wipe out data, the next identity value still starts from last value + 1 and not from 1. You will have to use DBCC CHECKIDENT statement with RESEED option to reset seed value to 1.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Problems with deleting and restarting a database