| 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. |
| 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 %d). |
| 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 '%.*ls' and '%.*ls' have the same exposed names. Use correlation names to distinguish them. |
| 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 | Cannot specify column list for INSERT/DELETE/EXECUTE privileges in the GRANT/REVOKE statement. |
| 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 | An ORDER BY clause is invalid in views, 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 | SHOWPLAN is not available. Use SHOWPLAN_TEXT or SHOWPLAN_ALL instead. |
| 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'. |
| 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. |
| 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 be corrupt. |
| 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 | SQL Server has run out of LOCKS. Rerun your statement when there are fewer active users, or ask the system administrator to reconfigure SQL Server with more LOCKS. |
| 1205 | 13 | Your transaction (process ID #%d) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your 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. |
| 1501 | 20 | Sort failure. |
| 1505 | 14 | CREATE UNIQUE INDEX terminated because a duplicate key was found. 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. |
| 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. |
| 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 | The total row size (%d) for table '%.*ls' exceeds the maximum number of bytes per row (%d). Rows that exceed the maximum number of bytes will not be added. |
| 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. |
| 1759 | 16 | Invalid column '%.*ls' specified in constraint 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. |
| 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 a accommodate 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'. |
| 1807 | 17 | Could not obtain exclusive lock on database '%.*ls'. Retry the operation later. |
| 1808 | 21 | Default devices are not supported. |
| 1811 | 16 | '%.*ls' is the wrong type of device for CREATE DATABASE or ALTER DATABASE. Check sysdevices. The statement is aborted. |
| 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. |
| 1816 | 16 | Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server. |
| 1817 | 10 | Warning: %ls %ld in database differs from server %ls of %ld. |
| 1818 | 16 | Primary log file '%ls' is missing and the database was not cleanly shut down so it cannot be rebuilt. |
| 1819 | 10 | Could not create default log file because the name was too long. |
| 1820 | 16 | Disk '%.*ls' is already completely used by other databases. It can be expanded with DISK RESIZE. |
| 1826 | 16 | User-defined filegroups are not allowed on '%hs'. |
| 1827 | 16 | CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of %d MB per %S_MSG. |
| 1828 | 16 | The file named '%.*ls' is already in use. Choose another name. |
| 1829 | 16 | The FOR ATTACH option requires that at least the primary file be specified. |
| 1830 | 16 | The files '%.*ls' and '%.*ls' are both primary files. A database can only have one primary file. |
| 1831 | 10 | Successfully %ls database '%.*ls'. |
| 1832 | 20 | Could not attach database '%.*ls' to file '%.*ls'. |
| 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 | %d is the maximum allowable size of an index. The composite index specified is %d bytes. |
| 1904 | 16 | Cannot specify more than %d column names for 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 table '%.*ls', because this table does not exist in database '%.*ls'. |
| 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 indexes 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 | Cannot create index on object '%.*ls' because it is not a user table. |
| 1915 | 16 | Only members of the sysadmin role or the owner of table '%.*ls' can create an index on it. |
| 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. |
| 1924 | 16 | Filegroup '%.*ls' is read-only. |
| 1925 | 16 | Cannot convert a clustered index to a nonclustered index using the DROP_EXISTING option. |
| 1926 | 16 | Cannot create a clustered index because nonclustered index ID %d is on a read-only filegroup. |
| 1927 | 16 | There are already statistics on table '%.*ls' named '%.*ls'. |
| 1928 | 16 | Cannot create statistics on table '%.*ls' because this table does not exist in database '%.*ls'. |
| 1929 | 16 | Cannot create statistics on table '%.*ls' because it is not a user table. |
| 1930 | 16 | Only the owner of table '%.*ls' or a member of the sysadmin fixed server role can create statistics on it. |