sql server - SQL New Column Error Because of Newsequentialid -


hi have big data , has column objectid , default value newsequentialid(). while trying create new column default value on table, got message ' error validating default column 'objectid''.

if yes dialog message, can happen? dont want impact our existing data.

could please explain situations.

thanks & regards

nothing happen. bug in management studio. have lot of tables in production such columns , never encountered problem within 6 years. using sql server 2008 r2.

click no:

enter image description here

click yes:

enter image description here

result:

enter image description here


Comments

Post a Comment