19

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.

2 Answers 2

6

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

19

Use CREATE TABLE, not the GUI.

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

13
  • 5
    @5arx: poke around the 5 year old critical bugs for MySQL. MS are quite sharp in comparison
    – gbn
    Commented Oct 26, 2011 at 10:08
  • 1
    @5arx Well, when you consider the number of products Microsoft supports and the new features they add with every release, I think it's understandable that an easily avoidable bug in the GUI should linger for years. It still looks bad to us as customers but as a developer I can understand. Commented Oct 26, 2011 at 13:11
  • 1
    @5arx: as a developer, use raw SQL like most folk do. This is why I've never seen this bug
    – gbn
    Commented Oct 26, 2011 at 13:22
  • 2
    I'm a developer who uses databases, not a database developer. I haven't seen anyone use raw SQL to create tables since the late 90s. My point is if you're releasing a GUI, make sure it works. That's all.
    – immutabl
    Commented Oct 26, 2011 at 13:31
  • 2
    The UI doesn't exactly get a lot of priority when it comes to killing bugs. The core engine does, which it should. The UI team doesn't exactly have a whole lot of guys on it so they get to what they can as dictated by management (if it isn't Azure at the moment it isn't getting fixed). :(
    – mrdenny
    Commented Oct 26, 2011 at 16:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.