Sql server newsequentialid error validating the default for column jean chatzky dating
GUIDs generated by using NEWSEQUENTIALID() are unique across multiple computers only if the source computer has a network card.
NEWSEQUENTIALID() returns the value that includes the MAC of the NIC of the system.
Usage of GUID/uniqueidentifer and it’s implication on fragmentation, and how newsequentialid() can help improve this, has been documented in various places A limitation of newsequentialid() is that it can only be used as a default value for a column, not as a function, in for example ad-hoc INSERT scripts.
By taking advantage of SQLCLR, this situation can be changed.
Both NEWID() and NEWSEQUENTIALID() are globally unique.
Starting of NEWSEQUENTIALID after the restart of the computer does not affect its globally uniqueness.
NEWSEQUENTIALID() function creates the GUIDs greater than the previously generated GUIDs, since the last restart of the system, because after restarting the system the next NEWSEQUENTIALID can be started from the lower range. When NEWSEQUENTIALID() is used in DEFAULT expressions, it cannot be combined with other scalar operators.For example, you cannot execute the following: CREATE TABLE my Table (Column A uniqueidentifier DEFAULT dbo.myfunction(NEWSEQUENTIALID())) ... Sql Exception: Violation of PRIMARY KEY constraint ‘PK_Logs’. You didn't specify your table and column names - so I just made up placeholders - do replace those with your actual table and column names!
It cannot be combined with other operators to form a complex scalar expression.