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

http://stackoverflow.com/questions/1015676/error-setting-newsequentialid-default-in-sql-server-2008 — Daniel Stackenland, Jun 03 '15 at 06:39

score 0 · Answer 1 · answered Jun 03 '15 at 06:41

0

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:

enter image description here

Click YES:

enter image description here

Result:

enter image description here

answered Jun 03 '15 at 06:41

Giorgi Nakeuri

35,155
8
47
75

I though It will impact our indexed columns or damage our data. Thank you so much Giorgi to make me clarify. – Onur CAN Jun 03 '15 at 07:31

SQL New Column Error Because of Newsequentialid

1 Answers1