Error validating the default for column id newsequentialid English aunty live sex
You should start a new thread always when you have a new issue if already exist thread is marked as resolved, experts may miss it :) Keep your column datatype VARCHAR(50) OR NVARCHAR(50) and give your default value with single quotes like '4F1C7212-CC8A-4E92-A4F5-278254185ED9' See if it works.
Every time a new record is created in the jobs table, I want the status to default to new, which has a guid of 4F1C7212-CC8A-4E92-A4F5-278254185ED9.
After restarting Windows, the GUID can start again from a lower range, but is still globally unique.
When a GUID column is used as a row identifier, using NEWSEQUENTIALID can be faster than using the NEWID function.
It seems every time I start doing a project using visual studio, I stumble upon all the possible bugs. I am able to ignore the message in visual studio 2010.
Let's hope it would work on the remote sql server I'm about to upload the data to next week. Is there a way to set the default value to a constant value.
Search for error validating the default for column id newsequentialid:
Also, I'm curious as to why you would want to use newsequentialid() when you don't have to.