Troubleshooting
Errors 1000 - 1999
| Error | Severity | Description (Message Text) |
| 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 '%.*ls' and '%.*ls' 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 | 16 | Cannot use the column prefix '%.*ls'. This must match the object in the UPDATE clause '%.*ls'. |
| 1033 | 16 | 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 | 16 | 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. |
| 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 '%ls' 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. |
| 1201 | 20 | The page_lock system function was called with a mode %d that is not permitted. |
| 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. |
| 1221 | 20 | Invalid lock class for release call. |
| 1222 | 13 | Lock request time out period exceeded. |
| 1223 | 16 | Attempting to release application lock '%.*ls' that is not currently held. |
| 1501 | 20 | Sort failure. |
| 1505 | 14 | CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID %d. Most significant primary key is '%S_KEY'. |
| 1507 | 10 | Warning: Deleted duplicate row. Primary key is '%S_KEY'. |
| 1508 | 14 | CREATE INDEX terminated because a duplicate row was found. Primary key is '%S_KEY'. |
| 1509 | 20 | Row compare failure. |
| 1510 | 17 | Sort failed. Out of space or locks in database '%.*ls'. |
| 1511 | 20 | Sort cannot be reconciled with transaction log. |
| 1522 | 20 | Sort failure. Prevented overwriting of allocation page in database '%.*ls' by terminating sort. |
| 1523 | 20 | Sort failure. Prevented incorrect extent deallocation by aborting sort. |
| 1528 | 21 | Character data comparison failure. An unrecognized Sort-Map-Element type (%d) was found in the server-wide default sort table at SMEL entry [%d]. |
| 1529 | 21 | Character data comparison failure. A list of Sort-Map-Elements from the server-wide default sort table does not end properly. This list begins at SMEL entry [%d]. |
| 1530 | 16 | CREATE INDEX with DROP_EXISTING was aborted because a row was out of order. Most significant offending primary key is '%S_KEY'. Explicitly drop and create the index instead. |
| 1531 | 16 | The SORTED_DATA_REORG option cannot be used for a nonclustered index if the keys are not unique within the table. CREATE INDEX was aborted because of duplicate keys. Primary key is '%S_KEY'. |
| 1532 | 20 | New sort run starting on page %S_PGID found extent not marked as shared. |
| 1533 | 20 | Cannot share extent %S_PGID among more than eight sort runs. |
| 1534 | 20 | Extent %S_PGID not found in shared extent directory. |
| 1535 | 20 | Cannot share extent %S_PGID with shared extent directory full. |
| 1536 | 20 | Cannot build a nonclustered index on a memory-only work table. |
| 1537 | 20 | Cannot suspend a sort not in row input phase. |
| 1538 | 20 | Cannot insert into a sort not in row input phase. |
| 1540 | 16 | Cannot sort a row of size %d, which is greater than the allowable maximum of %d. |
| 1619 | 21 | Could not open tempdb. Cannot continue. |
| 1620 | 21 | Cannot start C2 audit trace. SQL Server is shutting down. |
| 1621 | 10 | Server started with '-f'. Auditing will not be started. |
| 1701 | 16 | Creation of table '%.*ls' failed because the row size would be %d, including internal overhead. This exceeds the maximum allowable table row size, %d. |
| Error 1702 | 16 | CREATE TABLE failed because column '%.*ls' in table '%.*ls' exceeds the maximum of %d columns. |
| 1703 | 17 | Could not allocate disk space for a work table in database '%.*ls'. You may be able to free up space by using BACKUP LOG, or you may want to extend the size of the database by using ALTER DATABASE. |
| 1704 | 16 | Only members of the sysadmin role can create the system table '%.*ls'. |
| 1705 | 16 | You must create system table '%.*ls' in the master database. |
| 1706 | 16 | System table '%.*ls' was not created, because ad hoc updates to system catalogs are not enabled. |
| 1708 | 10 | Warning: The table '%.*ls' has been created but its maximum row size (%d) exceeds the maximum number of bytes per row (%d). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds %d bytes. |
| 1709 | 16 | Cannot use TEXTIMAGE_ON when a table has no text, ntext, or image columns. |
| 1750 | 10 | Could not create constraint. See previous errors. |
| 1752 | 16 | Could not create DEFAULT for column '%.*ls' as it is not a valid column in the table '%.*ls'. |
| 1753 | 16 | Column '%.*ls.%.*ls' is not the same length as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'. |
| 1754 | 16 | Defaults cannot be created on columns with an IDENTITY attribute. Table '%.*ls', column '%.*ls'. |
| 1755 | 16 | Defaults cannot be created on columns of data type timestamp. Table '%.*ls', column '%.*ls'. |
| 1756 | 10 | Skipping FOREIGN KEY constraint '%.*ls' definition for temporary table. |
| 1757 | 16 | Column '%.*ls.%.*ls' is not of same collation as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'. |
| 1759 | 16 | Invalid column '%.*ls' is specified in a constraint or computed-column definition. |
| 1760 | 16 | Constraints of type %ls cannot be created on columns of type %ls. |
| 1763 | 16 | Cross-database foreign key references are not supported. Foreign key '%.*ls'. |
| 1766 | 16 | Foreign key references to temporary tables are not supported. Foreign key '%.*ls'. |
| 1767 | 16 | Foreign key '%.*ls' references invalid table '%.*ls'. |
| 1768 | 16 | Foreign key '%.*ls' references object '%.*ls' which is not a user table. |
| 1769 | 16 | Foreign key '%.*ls' references invalid column '%.*ls' in referencing table '%.*ls'. |
| 1770 | 16 | Foreign key '%.*ls' references invalid column '%.*ls' in referenced table '%.*ls'. |
| 1772 | 16 | Foreign key '%.*ls' defines an invalid relationship between a user table and system table. |
| 1773 | 16 | Foreign key '%.*ls' has implicit reference to object '%.*ls' which does not have a primary key defined on it. |
| 1774 | 16 | The number of columns in the referencing column list for foreign key '%.*ls' does not match those of the primary key in the referenced table '%.*ls'. |
| 1776 | 16 | There are no primary or candidate keys in the referenced table '%.*ls' that match the referencing column list in the foreign key '%.*ls'. |
| 1777 | 14 | User does not have correct permissions on referenced table '%.*ls' to create foreign key '%.*ls'. |
| 1778 | 16 | Column '%.*ls.%.*ls' is not the same data type as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'. |
| 1779 | 16 | Table '%.*ls' already has a primary key defined on it. |
| 1780 | 20 | Could not find column ID %d in syscolumns for object ID %d in database ID %d. |
| 1781 | 16 | Column already has a DEFAULT bound to it. |
| 1784 | 16 | Cannot create the foreign key '%.*ls' because the referenced column '%.*ls.%.*ls' is a computed column. |
| 1785 | 16 | Introducing FOREIGN KEY constraint '%.*ls' on table '%.*ls' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. |
| 1786 | 16 | Either column '%.*ls.%.*ls' or referencing column '%.*ls.%.*ls' in foreign key '%.*ls' is a timestamp column. This data type cannot be used with cascading referential integrity constraints. |
| 1787 | 16 | Cannot define foreign key constraint '%.*ls' with cascaded DELETE or UPDATE on table '%.*ls' because the table has an INSTEAD OF DELETE or UPDATE TRIGGER defined on it. |
| 1788 | 16 | Cascading foreign key '%.*ls' cannot be created where the referencing column '%.*ls.%.*ls' is an identity column. |
| 1801 | 16 | Database '%.*ls' already exists. |
| 1802 | 11 | CREATE DATABASE failed. Some file names listed could not be created. Check previous errors. |
| 1803 | 17 | CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks. Total space allocated must be at least %d MB to accommodate a copy of the model database. |
| 1804 | 10 | There is no disk named '%.*ls'. Checking other disk names. |
| 1805 | 10 | The CREATE DATABASE process is allocating %.2f MB on disk '%.*ls'. |
| 1806 | 16 | CREATE DATABASE failed. The default collation of database '%.*ls' cannot be set to '%.*ls'. |
| 1807 | 17 | Could not obtain exclusive lock on database '%.*ls'. Retry the operation later. |
| 1808 | 21 | Default devices are not supported. |
| 1809 | 10 | To achieve optimal performance, update all statistics on the '%.*ls' database by running sp_updatestats. |
| 1811 | 16 | '%.*ls' is the wrong type of device for CREATE DATABASE or ALTER DATABASE. Check sysdevices. The statement is aborted. |
| 1812 | 16 | CREATE DATABASE failed. COLLATE clause cannot be used with the FOR ATTACH option. |
| 1813 | 16 | Could not open new database '%.*ls'. CREATE DATABASE is aborted. |
| 1814 | 10 | Could not create tempdb. If space is low, extend the amount of space and restart. |
| 1901 | 16 | Column '%.*ls'. Cannot create index on a column of bit data type. |
| 1902 | 16 | Cannot create more than one clustered index on table '%.*ls'. Drop the existing clustered index '%.*ls' before creating another. |
| 1903 | 16 | Index keys are too large. The %d bytes needed to represent the keys for index %d exceeds the size limit of %d bytes. |
| 1904 | 16 | Cannot specify more than %d column names for statistics or index key list. %d specified. |
| 1905 | 21 | Could not find 'zero' row for index '%.*ls' the table in sysindexes. |
| 1906 | 11 | Cannot create an index on '%.*ls', because this table does not exist in database '%.*ls'. |
| 1907 | 16 | Cannot re-create index '%.*ls'. The new index definition does not match the constraint being enforced by the existing index. |
| 1909 | 16 | Cannot use duplicate column names in index key list. Column name '%.*ls' listed more than once. |
| 1910 | 16 | Cannot create more than %d nonclustered indices or column statistics on one table. |
| 1911 | 16 | Column name '%.*ls' does not exist in the target table. |
| 1913 | 16 | There is already an index on table '%.*ls' named '%.*ls'. |
| 1914 | 16 | Index cannot be created on object '%.*ls' because the object is not a user table or view. |
| 1916 | 16 | CREATE INDEX options %ls and %ls are mutually exclusive. |
| 1918 | 10 | Index (ID = %d) is being rebuilt. |
| 1919 | 16 | Column '%.*ls'. Cannot create index on a column of text, ntext, or image data type. |
| 1920 | 10 | Skipping rebuild of index ID %d, which is on a read-only filegroup. |
| 1921 | 16 | Invalid filegroup '%.*ls' specified. |
| 1922 | 16 | Filegroup '%.*ls' has no files assigned to it. Tables, indexes, and text, ntext, and image columns cannot be created on this filegroup. |
| 1923 | 10 | The clustered index has been dropped. |
| 1938 | 16 | Index cannot be created on %S_MSG '%.*ls' because the underlying object '%.*ls' has a different owner. |
| 1939 | 16 | Index %S_MSG cannot be created on view '%.*ls' because the view is not schema bound. |
| 1940 | 16 | Cannot create %S_MSG on view '%.*ls'. It does not have a unique clustered index. |
| 1941 | 16 | Nonunique clustered index cannot be created on view '%.*ls' because only unique clustered indexes are allowed. |
| 1942 | 16 | Index cannot be created on view '%.*ls' because the view contains text, ntext or image columns. |
| 1943 | 16 | Index cannot be created on view '%.*ls' because the view has one or more nondeterministic expressions. |
| 1944 | 16 | Index '%.*ls' was not created. This index has a key length of at least %d bytes. The maximum permissible key length is %d bytes. |
| 1945 | 16 | Warning! The maximum key length is %d bytes. The index '%.*ls' has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail. |
| 1946 | 16 | Operation failed. The index entry of length %d bytes for the index '%.*ls' exceeds the maximum length of %d bytes. |
| 1947 | 16 | Index cannot be created on view '%.*ls' because the view contains a self-join on '%.*ls'. |
| 1948 | 16 | Duplicate index names '%.*ls' and '%.*ls' detected on table '%.*ls'. |
| 1949 | 16 | Index on view '%.*ls' cannot be created because function '%s' yields nondeterministic results. |
| 1950 | 16 | Index on view '%.*ls' cannot be created because the view contains an imprecise expression in a GROUP BY clause |
| 1951 | 16 | Index on view '%.*ls' cannot be created because the view contains an imprecise expression in the WHERE clause. |
| 1952 | 16 | Index on view '%.*ls' cannot be created because the view contains an imprecise expression in a join. |
| 1953 | 16 | Index on view '%.*ls' cannot be created because some arguments are missing in a built-in function. |
| 1954 | 16 | Index on view '%.*ls' cannot be created because the view uses a column bound to a rule. |
| 1955 | 16 | Index on view '%.*ls' cannot be created because the view contains a nondeterministic computed column. |
| 1956 | 16 | Index on view '%.*ls' cannot be created because the view uses a nondeterministic user-defined function. |
| 1957 | 16 | Index on view '%.*ls' cannot be created because the view requires a conversion involving dates or variants. |
| 1958 | 16 | This edition of SQL Server does not support indexed views. |
| 1959 | 16 | Cannot create index on view or computed column because this database is not SQL Server compatible. |