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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 20:16:15
|
Charlie writes "Just curious if there is a way to do maintenance on a DB that uses a unique RecID (incremented by 1) to get rid of the "gaps". For instance when I delete records, even if it is the last record, the number for the next added still goes up. I am just in testing phase for my project, so right now I have 30 or so items with RecID ranging from 1 to about 80. This project when finished however will be used for 10,000+ items. I was hoping to not run into any problems sooner than necessary with too large of RecID
Thanks" |
|
|
|
|
|
Maintenence on Incrementing Rows