I am also not sure how could this happen...but it shows the error message that "trying to insert an duplicate value into unique index column".
By the way...the way of reseeding is
exec sp_chgattribute @table_name, 'identity_burn_max', 0, @max_used_ident
Hi All,
Please advise why I kept on failing in creating non-clustered index on a large table? I have just created a clustered index on a numeric data type column and a non-clustered index on a varchar(255) data type column. But when I tried to create another non-clustered index on a...
Hi Gurus,
Is it possible that a identity column trying to insert a identity value that already exists in the table? What would be the reason to cause this? How I could fix it?
thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.