SQL Server Errors or Failures Error: 1067 to Error: 1086



Error: 1067, Severity: 15,
The SET SHOWPLAN statements must be the only statements in the batch.

Error: 1068, Severity: 16,
Only one list of index hints per table is allowed.

Error: 1069, Severity: 16,
Index hints are only allowed in a FROM or OPTION clause.

Error: 1070, Severity: 15,
CREATE INDEX option ‘%.*ls’ is no longer supported.

Error: 1071, Severity: 16,
Cannot specify a JOIN algorithm with a remote JOIN.

Error: 1072, Severity: 16,
A REMOTE hint can only be specified with an INNER JOIN clause.

Error: 1073, Severity: 15,
‘%.*ls’ is not a recognized cursor option for cursor %.*ls.

Error: 1074, Severity: 15,
Creation of temporary functions is not allowed.

Error: 1075, Severity: 15,
RETUN statements in scalar valued functions must include an argument.

Error: 1076, Severity: 15,
Function ‘%s’ requires at least %d argument(s).

Error: 1077, Severity: 15,
INSERT in to an identity column not allowed on table variables.

Error: 1078, Severity: 15,
‘%.*ls %.*ls’ is not a recognized option.

Error: 1079, Severity: 15,
A variable cannot be used to specify a search condition in a fulltext predicate when accessed through a cursor.

Error: 1080, Severity: 15,
The integer value %.*ls is out of range.

Error: 1081, Severity: 16,
%s does not allow specifying the database name as a prefix to the assembly name.

Error: 1082, Severity: 15,
%.*ls does not support synchronous triggers registration.

Error: 1083, Severity: 15,
OWNER is not a valid option for EXECUTE AS in the context of server and database level triggers.

Error: 1084, Severity: 15,
‘%.*ls’ is an invalid event type.

Error: 1085, Severity: 15,
‘%.*ls’ event type does not support event notifications.

Error: 1086, Severity: 16,
The FOR XML clause is invalid in views, inline functions, derived tables, and subqueries when they contain a set operator. To work around, wrap the SELECT containing a set operator using derived table syntax and apply FOR XML on top of it.

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.

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 *