Skip Navigation Links
SQL Server 2012
SQL Server 2014
SQL Server 2016
Practice Test
Tip of the Day : Example Uses of the IIF Logical Function
Home > Tips & Tricks > Error Messages 1001 to 1500
SQL Server Error Messages - Errors 1001 to 1500

A message number uniquely identifies each error message and the error message text describes the problem.  The error message text often includes placeholders for information (such as object names) to be inserted in the error message when it is displayed.  Unfortunately, the error message text does not tell you how to solve or work around the problem.  In this series of Error Messages list, we will try to provide you with ways on how to overcome or work around certain error messages.

Some error messages are self-explanatory and can easily be fixed, such as "Invalid object name".  Others are harder to fix or work around, especially by those who are new to SQL Server.  It is the intent of this page and succeeding pages (to come) to assist you in addressing or working around SQL Server error messages.

Error Severity Description
1001 16 Line %d: Length or precision specification %d is invalid.
1002 16 Line %d: Specified scale %d is invalid.
1003 15 Line %d: %ls clause allowed only for %ls.
1004 16 Invalid column prefix '%.*ls': No table name specified
1005 15 Line %d: Invalid procedure number (%d). Must be between 1 and 32767.
1006 15 CREATE TRIGGER contains no statements.
1007 15 The %S_MSG '%.*ls' is out of the range for numeric representation (maximum precision 38).
1008 15 The SELECT item identified by the ORDER BY number %d contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.
1010 15 Invalid escape character '%.*ls'.
1011 15 The correlation name '%.*ls' is specified multiple times in a FROM clause.
1012 15 The correlation name '%.*ls' has the same exposed name as table '%.*ls'.
1013 15 Tables or functions "Object Name" and "Object Name" have the same exposed names. Use correlation names to distinguish them.
1014 15 TOP clause contains an invalid value.
1015 15 An aggregate cannot appear in an ON clause unless it is in a subquery contained in a HAVING clause or select list, and the column being aggregated is an outer reference.
1016 15 Outer join operators cannot be specified in a query containing joined tables.
1019 15 Invalid column list after object name in GRANT/REVOKE statement.
1020 15 Column list cannot be specified for object-level permissions.
1021 10 FIPS Warning: Line %d has the non-ANSI statement '%ls'.
1022 10 FIPS Warning: Line %d has the non-ANSI clause '%ls'.
1023 15 Invalid parameter %d specified for %ls.
1024 10 FIPS Warning: Line %d has the non-ANSI function '%ls'.
1025 10 FIPS Warning: The length of identifier '%.*ls' exceeds 18.
1027 15 Too many expressions are specified in the GROUP BY clause. The maximum number is %d when either CUBE or ROLLUP is specified.
1028 15 The CUBE and ROLLUP options are not allowed in a GROUP BY ALL clause.
1029 15 Browse mode is invalid for subqueries and derived tables.
1031 15 Percent values must be between 0 and 100.
1032 15 Cannot use the column prefix '%.*ls'. This must match the object in the UPDATE clause '%.*ls'.
1033 15 The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
1035 15 Incorrect syntax near '%.*ls', expected '%.*ls'.
1036 15 File option %hs is required in this CREATE/ALTER DATABASE statement.
1037 15 The CASCADE, WITH GRANT or AS options cannot be specified with statement permissions.
1038 15 Cannot use empty object or column names. Use a single space if necessary.
1039 15 Option '%.*ls' is specified more than once.
1040 15 Mixing old and new syntax in CREATE/ALTER DATABASE statement is not allowed.
1041 15 Option %.*ls is not allowed for a LOG file.
1042 15 Conflicting %ls optimizer hints specified.
1043 15 '%hs' is not yet implemented.
1044 15 Cannot use an existing function name to specify a stored procedure name.
1045 15 Aggregates are not allowed in this context. Only scalar expressions are allowed.
1046 15 Subqueries are not allowed in this context. Only scalar expressions are allowed.
1047 15 Conflicting locking hints specified.
1048 15 Conflicting cursor options %ls and %ls.
1049 15 Mixing old and new syntax to specify cursor options is not allowed.
1050 15 This syntax is only allowed within the stored procedure sp_executesql.

Error Severity Description
1051 15 Cursor parameters in a stored procedure must be declared with OUTPUT and VARYING options, and they must be specified in the order CURSOR VARYING OUTPUT.
1052 15 Conflicting %ls options %ls and %ls.
1053 15 For DROP STATISTICS, you must give both the table and the column name in the form 'tablename.column'.
1054 15 Syntax '*' is not allowed in schema-bound objects.
1055 15 '%.*ls' is an invalid name because it contains a NULL character.
1056 15 The maximum number of elements in the select list is %d and you have supplied %d.
1057 15 The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION operator.
1058 15 Cannot specify both READ_ONLY and FOR READ ONLY on a cursor declaration.
1059 15 Cannot set or reset the %ls option within a procedure.
1060 15 The number of rows in the TOP clause must be an integer.
1061 16 The text/ntext/image constants are not yet implemented.
1062 16 The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.
1063 16 A filegroup cannot be added using ALTER DATABASE ADD FILE. Use ALTER DATABASE ADD FILEGROUP.
1064 16 A filegroup cannot be used with log files.
1065 15 The NOLOCK, READUNCOMMITTED, and READPAST lock hints are only allowed in a SELECT statement.
1066 10 Warning. Line %d: The option '%ls' is obsolete and has no effect.
1067 15 The SET SHOWPLAN statements must be the only statements in the batch.
1068 16 Only one list of index hints per table is allowed.
1069 16 Index hints are only allowed in a FROM clause.
1070 15 CREATE INDEX option '%.*ls' is no longer supported.
1071 16 Cannot specify a JOIN algorithm with a remote JOIN.
1072 16 A REMOTE hint can only be specified with an INNER JOIN clause.
1073 15 '%.*ls' is not a recognized cursor option for cursor %.*ls.
1074 15 Creation of temporary functions is not allowed.
1075 15 RETURN statements in scalar valued functions must include an argument.
1076 15 Function '%s' requires at least %d argument(s).
1077 15 INSERT into an identity column not allowed on table variables.
1078 15 '%.*ls %.*ls' is not a recognized option.
1079 15 A variable cannot be used to specify a search condition in a fulltext predicate when accessed through a cursor.
1101 17 Could not allocate new page for database '%.*ls'. There are no more pages available in filegroup %.*ls. Space can be created by dropping objects, adding additional files, or allowing file growth.
1102 22 IAM page %S_PGID for object ID %ld is incorrect. The %S_MSG ID on page is %ld; should be %ld. The entry in sysindexes may be incorrect or the IAM page may contain an error.
1103 21 Allocation page %S_PGID in database '%.*ls' has different segment ID than that of the object which is being allocated to. Run DBCC CHECKALLOC.
1105 17 Could not allocate space for object '%.*ls' in database '%.*ls' because the '%.*ls' filegroup is full.
1109 21 Could not read allocation page %S_PGID because either the object ID (%ld) is not correct, or the page ID (%S_PGID) is not correct.
1203 20 Process ID %d attempting to unlock unowned resource %.*ls.
1204 19 The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.
1205 13 Transaction (Process ID %d) was deadlocked on {%Z} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
1206 18 Transaction manager has canceled the distributed transaction.
1211 13 Process ID %d was chosen as the deadlock victim with P_BACKOUT bit set.
1220 17 No more lock classes available from transaction.
1222 13 Lock request time out period exceeded.
1223 16 Attempting to release application lock '%.*ls' that is not currently held.

Reference: Database Engine Events and Errors - SQL Server | Microsoft Docs

Related Articles :