SQL Server Errors or Failures Error: 1709 to Error: 1728

SQLServerF1

 

Error: 1709, Severity: 16,
Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), non-FILESTREAM varbinary(max), xml or large CLR type columns.

Error: 1710, Severity: 10,
Cannot use alias type with rule or default bound to it as a column type in table variable or return table definition in table valued function. Type ‘%.*ls’ has a %S_MSG bound to it.

Error: 1711, Severity: 16,
Cannot define PRIMARY KEY constraint on column ‘%.*ls’ in table ‘%.*ls’. The computed column has to be persisted and not nullable.

Error: 1712, Severity: 16,
Online index operations can only be performed in Enterprise edition of SQL Server.

Error: 1713, Severity: 16,
Cannot execute %ls on/using table ‘%.*ls’ since the table is the target table or part of cascading actions of a currently executing trigger.

Error: 1714, Severity: 16,
Altr table failed because unique column IDs have been exhausted for table ‘%.*ls’.

Error: 1715, Severity: 16,
Foreign key ‘%.*ls’ creation failed. Only NO ACTION referential update action is allowed for referencing computed column ‘%.*ls’.

Error: 1716, Severity: 16,
FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table.

Error: 1717, Severity: 16,
FILESTREAM_ON cannot be specified together with a partition scheme in the ON clause.

Error: 1718, Severity: 16,
Change tracking must be enabled on database ‘%.*ls’ before it can be enabled on table ‘%.*ls’.

Error: 1719, Severity: 16,
FILESTREAM data cannot be placed on an empty filegroup.

Error: 1720, Severity: 16,
Cannot drp FILESTREAM filegroup or partition scheme since table ‘%.*ls’ has FILESTREAM columns.

Error: 1721, Severity: 16,
Altering table ‘%.*ls’ failed because the row size using vardecimal storage format exceeds the maximum allowed table row size of %d bytes.

Error: 1722, Severity: 16,
Cannot %S_MSG %S_MSG ‘%.*ls’ since a partition scheme is not specified for FILESTREAM data.

Error: 1723, Severity: 16,
Cannot %S_MSG %S_MSG ‘%.*ls’ since a partition scheme was specified for FILESTREAM data but not for the table.

Error: 1724, Severity: 16,
Filegroup ‘%.*ls’ is not a FILESTREAM filegroup or partition scheme of FILESTREAM filegroups.

Error: 1725, Severity: 16,
Cannot add FILESTREAM column to %S_MSG ‘%.*ls’ because an INSTEAD OF trigger exists on the %S_MSG.

Error: 1726, Severity: 16,
Cannot add FILESTREAM filegroup or partition scheme since table ‘%.*ls’ has a FILESTREAM filegroup or partition scheme already.

Error: 1727, Severity: 16,
Cannot create non-clustered index ‘%.*ls’ on table ‘%.*ls’ with the FILESTREAM_ON clause.

Error: 1728, Severity: 16,
Cannot create index ‘%.*ls’ on table ‘%.*ls’ because the computed column ‘%.*ls’ uses a FILESTREAM column.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *