Re: Idendity column on MS SQL

Eugene V. Goldberg wrote:

Is there a way to remove the AutoInc flag, so i can put exact value
in the field?

You can't remove the flag (you have to drop and recreate the column),
but you can set the value of identity columns if you execute a SET
IDENTITY_INSERT statement:

http://msdn.microsoft.com/en-us/library/aa259221(SQL.80).aspx


--
Yorai Aminov (TeamB)
(TeamB cannot answer questions received via email.)
Shorter Path - http://www.shorterpath.com
Yorai's Page - http://www.yoraispage.com
.