Identity Seed : Implications of making it zero

Hi,
The default for the seed is 1. HAs anyone tried creating a
seed starting at 0 instead. What are the problems/comments
on this?
Any feedback is appreciated.
Thanks
AnnaImplication will be that you'll get one extra possible value :)
Seriously, no problem at all. You can use negative numbers if you want.
Everyone just pretty much uses 1 due to convention.
"Anna" <anonymous@.discussions.microsoft.com> wrote in message
news:0c0601c49a7c$4d843a30$a601280a@.phx.gbl...
> Hi,
> The default for the seed is 1. HAs anyone tried creating a
> seed starting at 0 instead. What are the problems/comments
> on this?
> Any feedback is appreciated.
> Thanks
> Anna|||No problems, your new identity values will start from 0 instead of 1.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Anna" <anonymous@.discussions.microsoft.com> wrote in message
news:0c0601c49a7c$4d843a30$a601280a@.phx.gbl...
> Hi,
> The default for the seed is 1. HAs anyone tried creating a
> seed starting at 0 instead. What are the problems/comments
> on this?
> Any feedback is appreciated.
> Thanks
> Anna|||> Everyone just pretty much uses 1 due to convention.
And then get an overflow when the value reaches maxint. ;-)
Seriously, Anna, it even makes more sense to start with the lowest int in
potentially big tables.
--
BG, SQL Server MVP
www.SolidQualityLearning.com
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:ulUM8znmEHA.3396@.tk2msftngp13.phx.gbl...
> Implication will be that you'll get one extra possible value :)
> Seriously, no problem at all. You can use negative numbers if you want.
> Everyone just pretty much uses 1 due to convention.
>
> "Anna" <anonymous@.discussions.microsoft.com> wrote in message
> news:0c0601c49a7c$4d843a30$a601280a@.phx.gbl...
>> Hi,
>> The default for the seed is 1. HAs anyone tried creating a
>> seed starting at 0 instead. What are the problems/comments
>> on this?
>> Any feedback is appreciated.
>> Thanks
>> Anna
>|||"Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in message
news:uI0F4GomEHA.3356@.TK2MSFTNGP14.phx.gbl...
> And then get an overflow when the value reaches maxint. ;-)
>
The proactive DBA would have re-seeded before hitting that!