I'm trying to create a table in Management Studio and after reading about the new (from SQL 2005 on) NEWSEQUENTIALID()
function, thought I'd give it a go.
This is what I'm doing:
But it's not letting me. The error message I get is:
'FormTemplate (Forms)' table - Error validating the default for column 'FormTemplateId'.
Am I missing a trick here? I'm definitely running SQL Server 2008 R2.
Best Answer
You can work around this bug in SQL Server Management Studio just by ignoring the first and second warning. Changes will be saved.