Posted by Marcin A. Guzowski on 06/27/07 20:28

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 Guzowski
http://guzowski.info

• 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: Forcing an IDENTITY column to have a certain value
• Thread view: Re: Forcing an IDENTITY column to have a certain value

[Reply to this message]