Why can't I use NEWSEQUENTIALID() as the default value for my column?

Question

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:

enter image description here

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.

score 19 · Answer 1 · edited Mar 05 '12 at 21:36

19

Use CREATE TABLE, not the GUI.

This is a bug in SSMS, already reported here as well as here on Connect.

edited Mar 05 '12 at 21:36

Nick Chammas

14,810
17
76
124

answered Oct 26 '11 at 09:51

gbn

70,237
8
167
244

score 6 · Accepted Answer · answered May 22 '12 at 15:06

6

You can work around this bug in SQL Server Management Studio just by ignoring the first and second warning. Changes will be saved.

answered May 22 '12 at 15:06

splattne

242
3
10

Why can't I use NEWSEQUENTIALID() as the default value for my column?

2 Answers2