Posted by Weyus on 06/27/07 21:02

On Jun 27, 3:28 pm, "Marcin A. Guzowski"
<tu_wstaw_moje_i...@guzowski.info> wrote:
> Weyus wrote:
> > All,
>
> > Is there any way to _set_ an IDENTITY column to have a certain value
> > so as to create a gap in the set of identity values on purpose?
>
> > All I've found is SET IDENTITY_INSERT.
>
> There is also a DBCC command:
> DBCC CHECKIDENT ('table_name', reseed, new_value)
>
> --
> Best regards,
> Marcin Guzowskihttp://guzowski.info

Thanks,
That's what I needed!

Wes

• Next in forum: Re: How to reliably ensure that only one set of rows is bulk imported into a table at a time
• Prev in forum: Re: How to reliably ensure that only one set of rows is bulk imported into a table at a time
• Thread view: Re: Forcing an IDENTITY column to have a certain value

[Reply to this message]