SQL Server Helper - Error Message 1001 to 1500

Tip of the Day : SQL Server Database Design - Twitter Profile and Followers

Home > Tips & Tricks > Error Messages 1001 to 1500

SQL Server Error Messages - Errors 1001 to 1500

SQL Server Error Message - 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