Error validating the default for column id newsequentialid
The first command works fine but the second turns out showing an error message 'error validating the default for column xxxx' Any advice on this? If that is the case, you can set the Column an Identity column and primary key.
It has many downsides which newid() does not, and none of the benefits - the biggest being that newid() is not practically predictable, whereas newsequentialid() is.
After restarting Windows, the GUID can start again from a lower range, but is still globally unique.