October 8, 2014 at 6:45 pm
Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
we are using the default of newsequentialID() as the key on some tables and getting the error
Error validating the default for column xxx
When first saving the table if the value is entered as
newsequentialid()
the save works but on any subsequent design change I get the error.
If you click Yes to continue it works fine.
The value that is in there once its saved shows up as
(newsequentialid())
if you change it back to not have the outer parenthesis it saves without issue
Mostly curious as to why it does this and if there is some other issue i should be aware of.
Thanks,
Tom
October 8, 2014 at 8:49 pm
Quick thought, this is an SSMS flaw when changing a table in design view, a workaround would be using DDL statements (ALTER TABLE) instead of the design view.
😎
October 8, 2014 at 9:43 pm
yeah it works fine using a ddl statement, its more just an annoyance but was curious about it....
October 8, 2014 at 10:04 pm
For fun, maybe do a trace to see what SSMS is doing wrong?
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply