Posted by Dan Guzman on 09/18/05 20:58

http://support.microsoft.com/default.aspx?scid=kb;en-us;835188

--
Hope this helps.

Dan Guzman
SQL Server MVP

"helmut woess" <hw@iis.at> wrote in message
news:1q6jrdv4416ek.9i6nx8fks7bc$.dlg@40tude.net...
> Hi,
>
> can somebody explain me, why the IDENT_CURRENT from an empty table is 1?
> After insert of the first record it is still 1 (assuming that start value
> is 1) which is okay. But if i check the IDENT_CURRENT from a newly created
> table the result should be NULL, or not?
>
> bye,
> Helmut

[Back to original message]