Error validating the default for column id newsequentialid Chatropolia
I used the Access 2003 upsizing Wiz to migrate to SQL-Server 2005. When editing a table design, I get errors when saving. Actually, each rec already had a GUID-ID autovalue column in Access. in such case change the datatype in sql server for that column to Varchar(100) instead of rowguid.
Otherwise, it seems to behave similarly to newid() / Row Guid.Also, I'm curious as to why you would want to use newsequentialid() when you don't have to.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.This is because the NEWID function causes random activity and uses fewer cached data pages.
Using NEWSEQUENTIALID also helps to completely fill the data and index pages.For example, I have a status field which links to a table with different status values.