This site uses cookies. By continuing, your consent is assumed. Learn more

124.9fm shares

Newsequentialid error validating the default for column addition

opinion
Your Answer

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Hi I have a really big data and it has a column as ObjectID and its default value newsequentialid.

While I am trying to create new column with a default value on that table, I got this message ' Error validating the default for column 'ObjectID''. This is bug in the management studio.

NewSequentialID - Error validating the...

We have a lot of tables in production with such columns and never encountered any problem within 6 years. We are using Sql Server R2. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

If I say yes to that dialog message, what can happen? I dont want to impact our existing data.

Could you please explain this situations. Giorgi Nakeuri 31k 7 25 I though It will impact our indexed columns or damage our data.

Thank you so much Giorgi to make me clarify. Sign up or log in Sign up using Google.

News feed