:::: MENU ::::

The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type ‘uniqueidentifier’ in a CREATE TABLE or ALTER TA

  • Dec 29 / 2008
  • 0
dbDigger, System Functions

The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type ‘uniqueidentifier’ in a CREATE TABLE or ALTER TA

The error message
Msg 302, Level 16, State 0, Line 1
The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type ‘uniqueidentifier’ in a CREATE TABLE or ALTER TABLE statement. It cannot be combined with other operators to form a complex scalar expression.
is a run time error message of severity level 16. This error is introduced in SQL Server 2005. This error message appears when you try to call the newsequentialid() function outside the scope of a DEFAULT expression for a column. To remove the error make sure that Newsequentialid() can only be used within a DEFAULT expression of a column.

Consult us to explore the Databases. Contact us