SQL New Column Error Because of Newsequentialid

Question

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''.

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.

Thanks & Regards

Answer 1

Nothing will happen. This is bug in the management studio. We have a lot of tables in production with such columns and never encountered any problem within 6 years. We are using Sql Server 2008 R2.

Click NO:

Click YES:

Result: