Comments (21) | Workarounds (3) | Attachments (0) Sign in to post newsequentialid error a comment. Submit Posted by Data System Architect on 8/26/2015 at AM Got SQL 2014.
Running this in ssms results in squential guids: insert into Table_1 (Name) values('test13a'); insert into Table_1 (Name) values('test14a'); insert into Table_1 (Name) values('test15a'); insert into Table_1 (Name) values('test16a'); insert into Table_1 (Name) values('test17a'); sql-server share|improve this question edited Apr 10 '09 at asked Apr 10 '09 at P a u l 3,49394483 Where does newsequentialid() come from?
–Sir Demon Apr 10 '09 at It's a bad function name.
The fix is risky to implement in the current version of the product (service packs)2.
Scenarios reported in the bug are not common enough3.
The GUIDs aren't sequential, rather they are monotonically increasing.
For this type of guid, 47 bytes are the MAC address, 16 are clock cycle, and 60 bits are the time since 15 October 1582 in 100 nanosecond increments.
A more detailed explanation for the resolution of this particular item may have been provided in the comments section.
59 0 Sign into vote ID 472092 Comments 21 Status Closed Workarounds https://connect.microsoft.com/SQLServer/feedback/details/472092/newsequentialid-bug-in-management-studio 3 Type Bug Repros 30 Opened 7/2/2009 AM Access Restriction Public Description management studio always gives an error message for tables in which NEWSEQUENTIALID() is used for a default uniqueidentifier column.
As I am programmer first and database administrator only when needed, my natural environment when dealing with database is right-clicking Design and doing changes in more visual way. The scripts ran fine converting them to clustered indexes, but I wanted to know what this error was about and it led me to this page. Reply Leave a Reply Cancel reply Your Comment You may use these HTML tags and attributes: newsequentialid error validating Newsequentialid Error Validatinghere for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of million programmers just like you helping each other Join them it only takes a minute Sign up Error setting newsequentialid default in sql server up vote down vote There are many reasons why Newsequentialid Error Validating Default happen, including having malware, spyware, or programs not installing properly.