Error validating the default for column newsequentialid

Posted by / 03-Jul-2017 18:42

If the table is not partitioned, the FILESTREAM column cannot be partitioned.

FILESTREAM data for the table must be stored in a single filegroup.

This filegroup is specified in the FILESTREAM_ON clause.

If the table is not partitioned and the FILESTREAM_ON clause is not specified, the FILESTREAM filegroup that has the DEFAULT property set is used.

If CLUSTERED is specified or the constraint otherwise creates a clustered index, and a Note In this context, default is not a keyword.For more information, see Indexes on Computed Columns.Any computed columns that are used as partitioning columns of a partitioned table must be explicitly marked PERSISTED.TEXTIMAGE_ON is not allowed if there are no large value columns in the table. If "default" is specified, or if TEXTIMAGE_ON is not specified at all, the large value columns are stored in the default filegroup.The storage of any large value column data specified in CREATE TABLE cannot be subsequently altered.

error validating the default for column newsequentialid-3error validating the default for column newsequentialid-35error validating the default for column newsequentialid-83

It is an identifier for the default filegroup and must be delimited, as in ON "default" or ON [default].

One thought on “error validating the default for column newsequentialid”