> But won't it eventually come back in and fill in some of those ones that
> were previously deleted? As in your example, at some point won't
> another item get assigned the value of 4?
MSSQL servers identity columns just keep going untill it they fill up a signed 32
bit integer (I believe might even be larger 2,147,483,648), at that point it flips around
and starts over at 1. So unless you think you'll get that many request between inserts
- which would be rad! - you should be fine.
--
Rob <[EMAIL PROTECTED]>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
