SQL Server Error Messages 2001 to 3000

In this post, we’ll list out the SQL Server Error Messages from the error codes 2001 to 3000 and references to the detailed post to know more about the errors and how to fix them when using SQL Server as database in your application.

SQL Server Error Messages 2001 to 3000

ErrorCodeSeverityErrorMessage
200216Cannot create a procedure for replication with group number greater than one.
200316Procedures with a group number cannot have parameters of XML, CLR or encrypted types. Parameter ‘%.*ls’ of procedure ‘%.*ls’ has type ‘%ls’.
200416Procedure ‘%.*ls’ has already been created with group number %d. Create procedure with an unused group number.
200516The table ‘%.*ls’ is unavailable and needs to be rebuilt. Rebuild the table offline.
200710The module ‘%.*ls’ depends on the missing object ‘%.*ls’. The module will still be created; however, it cannot run successfully until the object exists.
200816The object ‘%.*ls’ is not a procedure so you cannot create another procedure under that group name.
201016Cannot perform alter on ‘%.*ls’ because it is an incompatible object type.
201116Index hints within a schema-bound object can be applied only to memory optimized tables.
201310Warning: ‘is_ms_shipped’ property is turned off for %S_MSG ‘%.*ls’ because you do not have permission to create or alter an object with this property.
201416Remote access is not allowed from within a schema-bound object.
202016The dependencies reported for entity “%.*ls” might not include references to all columns. This is either because the entity references an object that does not exist or because of an error in one or more statements in the entity.  Before rerunning the query, ensure that there are no errors in the entity and that all objects referenced by the entity exist.
202116The referenced entity ‘%.*ls’ was modified during DDL execution. Please retry the operation.
202216Parsing errors were encountered in the %S_MSG ‘%.*ls’. The dependencies referenced from this object could not be determined.
202310Metadata was not updated for the schema-bound object ‘%ls’.
210114Cannot %S_MSG a server level %S_MSG for user ‘%.*ls’ since there is no login corresponding to the user.
210216Cannot %S_MSG %S_MSG ‘%.*ls’ since there is no user for login ‘%.*ls’ in database ‘%.*ls’.
210315Cannot %S_MSG trigger ‘%.*s’ because its schema is different from the schema of the target table or view.
210414Cannot %S_MSG the %S_MSG ‘%.*ls’, because you do not have permission.
210815Cannot %S_MSG %S_MSG on ‘%.*ls’ as the target is not in the current database.
211015Cannot alter trigger ‘%.*ls’ on ‘%.*ls’ because this trigger does not belong to this object. Specify the correct trigger name or the correct target object name.
211116Cannot %S_MSG trigger ‘%.*ls’ on %S_MSG ‘%.*ls’ because an INSTEAD OF %s trigger already exists on this object.
211216Cannot create trigger ‘%.*ls’ on view ‘%.*ls’ because the view is defined with CHECK OPTION.
211316Cannot %S_MSG INSTEAD OF DELETE or INSTEAD OF UPDATE TRIGGER ‘%.*ls’ on table ‘%.*ls’. This is  because the table has a FOREIGN KEY with cascading DELETE or UPDATE.
211416Column ‘%.*ls’ cannot be used in an IF UPDATE clause because it is a computed column.
211516Server level event notifications are disabled as the database msdb does not exist.
211616Cannot CREATE EVENT NOTIFICATION to database ‘%.*ls’ because it is not a valid broker database.
211716Cannot %S_MSG INSTEAD OF trigger ‘%.*ls’ on %S_MSG ‘%.*ls’ because the %S_MSG has a FILESTREAM column.
220116%sDerivation from “anySimpleType” by restriction is not permitted, and derivation by restriction from a type derived from “anySimpleType” by extension is allowed only if no constraining facets are specified.
220216%sAn error has occurred while compiling the query. To obtain more detailed information about the error, the query must be run by a user with EXECUTE permissions on the xml schema collection used in the query.
220316%sOnly ‘http://www.w3.org/2001/XMLSchema#decimal?’, ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed as predicates, found ‘%ls’
220416%sOnly ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed in conditions and with logical operators, found ‘%ls’
220516%s”%ls” was expected.
220616%sNamespace prefix ‘xml’ can only be associated with the URI ‘http://www.w3.org/XML/1998/namespace’ and this URI cannot be used with other prefixes.
220716%sOnly non-document nodes can be inserted. Found “%ls”.
220816%sThe URI that starts with ‘%ls’ is too long. Maximum allowed length is %d characters.
220916%sSyntax error near ‘%ls’
221016%sHeterogeneous sequences are not allowed: found ‘%ls’ and ‘%ls’
221116%sSingleton (or empty sequence) required, found operand of type ‘%ls’
221216%sInvalid source character ‘%c’ (0x%02x) found in an identifier near ‘%ls’.
221316%sCannot atomize/apply data() on expression that contains type ‘%ls’ within inferred type ‘%ls’
221416%sThe type ‘%ls’ is not an atomic type
221516%sThe value of attribute ‘%ls’ exceeds 4000 characters, the maximum permitted in XML schema documents
221616%sInvalid XPath value in “%ls”.
221716%s’%ls’ or ‘%ls’ expected
221816%sThere is no attribute named ‘@%ls’
221916%sThere is no attribute named ‘@%ls’ in the type ‘%ls’.
222016%sThere is no attribute named ‘@%ls:%ls’
222116%sThere is no attribute named ‘@%ls:%ls’ in the type ‘%ls’.
222216%sInvalid source character 0x%02x found in an identifier near ‘%ls’.
222316%sSyntax error near ‘%ls’, expected an identifier.
222516%sA string literal was expected
222616%sThe target of ‘insert’ must be a single node, found ‘%ls’
222716%sThe variable ‘%ls’ was not found in the scope in which it was referenced.
222816%sThe variable ‘%ls:%ls’ was not found in the scope in which it was referenced.
222916%sThe name “%ls” does not denote a namespace.
223016%sThe name “%ls” has already been defined.
223116%sThe name “%ls” does not denote a defined type.
223216%sThe name “%ls:%ls” does not denote a defined type.
223316%sThe operand of “%ls” has an invalid type.
223416%sThe operator “%ls” cannot be applied to “%ls” and “%ls” operands.
223516%sAn argument list was applied to a non-function term.
223616%sThere are not enough actual arguments in the call to function “%ls”.
223716%sDerivation from anyType by extension is not supported in this release.
223816%sToo many arguments in call to function ‘%ls’
224016%sThe target of ‘insert into’ must be an element/document node, found ‘%ls’
224116%sVariable expected: ‘$name’
224216%sType specification expected.
224316%sRelative path expression used without any context
224716%sThe value is of type “%ls”, which is not a subtype of the expected type “%ls”.
224816%sSyntax error near ‘%ls’, expected ‘as’, ‘into’, ‘before’ or ‘after’.
224916%sThe target of ‘insert before/after’ must be an element/PI/comment/text node, found ‘%ls’
225616%sSyntax error near ‘%ls’, expected a “node test”.
225816%sThe position may not be specified when inserting an attribute node, found ‘%ls’
226016%sThere is no element named ‘%ls’
226116%sThere is no element named ‘%ls’ in the type ‘%ls’.
226216%sThere is no element named ‘%ls:%ls’
226316%sThere is no element named “%ls:%ls” in the type “%ls”.
226416%sOnly non-document nodes may be deleted, found ‘%ls’
226616%sExpected end tag ‘%ls:%ls’
226716%sExpected end tag ‘%ls’
226816%sEnd tag ‘/%ls:%ls’ has no matching begin tag
226916%sEnd tag ‘/%ls’ has no matching begin tag
227016%sDuplicate attribute ‘%ls:%ls’
227116%sDuplicate attribute ‘%ls’
227216%s’?>’ expected
227316%sUnterminated CDATA section
227416%sUnterminated string constant (started on line %u)
227516%sUnterminated XML declaration
227616%sDerivation from ‘QName’ by restriction is not supported in this release
227716%sA tag name may not contain the character ‘%c’
227816%sA tag name may not start with the character ‘%c’
227916%sA name/token may not start with the character ‘%c’
228016%s<! was not followed by a valid construct
228116%sCannot construct DTDs in XQuery
228216%sInvalid entity reference
228316%sThe character ‘%c’ may not be part of an entity reference
228416%sThe namespace prefix ‘%ls’ has not been defined
228516%sInvalid numeric entity reference
229116%sNo root element was found.
229216%sWhen a type with simple content restricts a type with mixed content, it must have an embedded simple type definition. Location: ‘%ls’.
229316%sChoice cannot be empty unless minOccurs is 0. Location: ‘%ls’.
229416%s’xml’ is not allowed as a processing instruction target.
229716%sElement <%ls> is not valid at location ‘%ls’.
229816%sAttribute ‘%ls’ is not valid at location ‘%ls’.
229916%sRequired attribute “%ls” of XSD element “%ls” is missing.
230016%sRequired sub-element “%ls” of XSD element “%ls” is missing.
230116%sThe element “%ls” has already been defined.
230216%sThe name “%ls” has already been defined in this scope.
230516%sElement or attribute type specified more than once. Location: ‘%ls’.
230616%sThe qualified name “%ls” was found in a context where only NCName is allowed.
230716%sReference to an undefined name ‘%ls’
230816%sReference to an undefined name ‘%ls’ within namespace ‘%ls’
230916%sThe value of “%ls” is not a valid number.
231016%sThe attribute “%ls” is declared more than once.
231116%sThe attribute “%ls” is declared more than once within “%ls”.
231216%sThe value of attribute ‘%ls’ does not conform to the type definition ‘http://www.w3.org/2001/XMLSchema#%ls’: ‘%ls’.
231316%sThe attribute “%ls” cannot have a value of “%ls”.
231416%sThe attribute “%ls” cannot have a negative value.
231516%sThe attribute “%ls” should have a string value.
231616%sThe required ‘base’ attribute is missing. Location: ‘%ls’.
231716%sThe base type “%ls” defined on XSD element “%ls” is not a simple type.
231916%sThis type may not have a ‘%ls’ facet. Location: ‘%ls’.
232016%sDuplicate facet ‘%ls’ found at location ‘%ls’.
232116%sFacets cannot follow attribute declarations. Found facet ‘%ls’ at location ‘%ls’.
232216%sThe element type is not a subclass of the substitution group’s head
232316%sThe end tag ‘%ls’ doesn’t match opening tag ‘%ls’ from line %u
232416%sThe end tag ‘%ls:%ls’ doesn’t match opening tag ‘%ls’ from line %u
232516%sThe end tag ‘%ls’ doesn’t match opening tag ‘%ls:%ls’ from line %u
232616%sThe end tag ‘%ls:%ls’ doesn’t match opening tag ‘%ls:%ls’ from line %u
232716%sThe content or definition of <%ls> is missing.
232816%sSchema namespace ‘%ls’ doesn’t match <include> directive’s ‘%ls’
232916%sThe string “%ls” is not a valid time duration value.
233116%sRedefinition has to have itself as base type. Location: ‘%ls’.
233216%s’%ls’ may not be used with an ’empty’ operand
233316%sInvalid source character 0x%02x
233416%sInvalid source character ‘%c’ (0x%02x)
233516%sNewline in character/string constant
233616%s’%c’ is not a valid octal digit (numbers starting with ‘0’ are implicitly octal)
233716%sThe target of ‘replace’ must be at most one node, found ‘%ls’
233816%sThe second ‘replace’ operand must contain only nodes, found ‘%ls’
233916%sEither a memberType attribute or a simpleType child must be present. Location: ‘%ls’.
234016%sComment started on line %u has no end
234116%sExpected hex character code following ‘\\x’
234216%sInvalid numeric constant.
234316%sUnterminated text section – missing `
234816%sA namespace URI should contain at least one non-whitespace character.
234916%sAttempt to redefine namespace prefix ‘%ls’
235016%sInvalid XML element content
235116%sExpected ‘first’ or ‘last’
235316%s’to’ or ‘insert’ or ‘delete’ expected
235416%sInvalid source character encoding
235516%s’else’ expected
235616%sThe target of ‘replace value of’ must be a non-metadata attribute or an element with simple typed content, found ‘%ls’
235716%sA document node may only be replaced with another document node, found ‘%ls’
235816%sDerivation with both a ‘base’ attribute and an embedded type definition is not supported in this release. Location: ‘%ls’.
235916%sThe target of ‘%ls’ may not be a constructed node
236016%sCannot have both a ‘name’ and ‘ref’ attribute. Location: ‘%ls’.
236116%sThe base type of an XSD extension or restriction type must be a simple type.
236216%sXSD schema too complex
236316%sXQuery too complex
236416%sCannot implicitly convert from ‘%ls’ to ‘%ls’
236516%sCannot explicitly convert from ‘%ls’ to ‘%ls’
236616%s”%ls” has a circular definition.
236716%sThe item type of an XSD list type must be a simple type. Location: ‘%ls’.
236816%sCannot have element content in a complex type with simple content. Location: ‘%ls’.
236916%sCannot have more than one group/sequence/choice/all within a restriction or extension. Location: ‘%ls’.
237016%sNo more tokens expected at the end of the XQuery expression. Found ‘%ls’.
237116%s’%ls’ can only be used within a predicate or XPath selector
237216%sMetadata attribute ‘@%ls:%ls’ may not be used with ‘%ls’
237316%s%ls is not supported with constructed XML
237416%sA node or set of nodes is required for %ls
237516%sAggregate function ‘%ls’ expects a sequence argument
237616%sOperand of a single numeric type expected
237716%sResult of ‘%ls’ expression is statically ’empty’
237816%sExpected XML schema document
237916%sThe name specified is not a valid XML name :’%ls’
238016%sMixed content is not allowed at location ‘%ls’.
238216%sInvalid combination of minOccurs and maxOccurs values, minOccurs has to be less than or equal to maxOccurs. Location: ‘%ls’.
238316%sInvalid value ‘%ls’ for the %ls attribute. The value has to be between 0 and %ld.
238416%sInvalid element occurrence, element ‘%ls’ was found multiple times in the context of element ‘%ls’
238516Invalid target namespace specified
238616%sThe value of ‘%ls’ facet is outside of the allowed range
238716%sCannot have both ‘type’ and ‘ref’ attributes. Location: ‘%ls’.
238816%sInvalid element occurrence, element ‘%ls’ has to appear first in the context of ‘%ls’
238916%s’%ls’ requires a singleton (or empty sequence), found operand of type ‘%ls’
239016%sTop-level %s nodes are not supported
239116%sRedefining XSD schemas is not supported
239216%s’%ls::’ is not a valid axis
239316%sEither an itemType attribute or a simpleType child must be present. Location: ‘%ls’.
239416%sThere is no function ‘%ls()’
239516%sThere is no function ‘%ls:%ls()’
239616%sAttribute may not appear outside of an element
239716%sIdentifiers may not contain more than %u characters
239816%sDuplicate id value found: ‘%ls’
239916%sAn attribute cannot have a value of type ‘%ls’, a simple type was expected
243110Error [%d, %d, %d] occurred while attempting to deallocate workfile extent with extent ID [%d:%d].
250116Cannot find a table or object with the name “%.*ls”. Check the system catalog.
250216Memory object list dump failed due to temporary inconsistency in the memory object structure. Please try again.
250310Successfully deleted the physical file ‘%ls’.
250416Could not delete the physical file ‘%ls’. The DeleteFile system function returned error %ls.
250516The device ‘%.*ls’ does not exist. Use sys.backup_devices to show available devices.
250616Could not find a table or object name ‘%.*ls’ in database ‘%.*ls’.
250716The CONCAT_NULL_YIELDS_NULL option must be set to ON to run DBCC CHECKCONSTRAINTS.
250816The %.*ls count for object “%.*ls”, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) is incorrect. Run DBCC UPDATEUSAGE.
250916DBCC CHECKCONSTRAINTS failed due to an internal query error. Please run DBCC CHECKDATABASE to ensure your data consistency.
251016DBCC %ls error: %ls.
251116Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). Keys out of order on page %S_PGID, slots %d and %d.
251216Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). Duplicate keys on page %S_PGID slot %d and page %S_PGID slot %d.
251316DBCC DBREINDEX cannot be used on memory optimized tables.
251416A DBCC PAGE error has occurred: %ls.
251516The page %S_PGID, object ID %d, index ID %d, partition ID %I64d, allocation unit ID %I64d (type %.*ls) has been modified, but is not marked as modified in the differential backup bitmap.
251616Repair has invalidated the differential bitmap for database %.*ls. The differential backup chain is broken. You must perform a full database backup before you can perform a differential backup.
251716Bulk-logging has been turned on for database %.*ls. To ensure that all data has been secured, run backup log operations again.
251810Object ID %ld (object “%.*ls”): Computed columns and CLR types cannot be checked for this object because the common language runtime (CLR) is disabled.
251910Computed columns and CLR types cannot be checked for object ID %ld (object “%.*ls”) because the internal expression evaluator could not be initialized.
252016Could not find database ‘%.*ls’. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.
252116Could not find database ID %d. The database ID either does not exist, or the database was dropped before a statement tried to use it. Verify if the database ID exists by querying the sys.databases catalog view.
252216Unable to process index %.*ls of table %.*ls because filegroup %.*ls is invalid.
252316Filegroup %.*ls is invalid.
252416Cannot process object ID %ld (object “%.*ls”) because it is a Service Broker queue. Try the operation again with the object ID of the corresponding internal table for the queue, found in sys.internal_tables.
252516Database file %.*ls is offline.
252616Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.
252716Unable to process index %.*ls of table %.*ls because filegroup %.*ls is offline.
252810DBCC execution completed. If DBCC printed error messages, contact your system administrator.
252916Filegroup %.*ls is offline.
253016The index “%.*ls” on table “%.*ls” is disabled.
253116Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) B-tree level mismatch, page %S_PGID. Level %d does not match level %d from the previous %S_PGID.
253216One or more WITH options specified are not valid for this command.
253316Table error: page %S_PGID allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
253416Table error: page %S_PGID, whose header indicates that it is allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), is allocated by another object.
253610DBCC results for ‘%.*ls’.
253716Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d. The record check (%.*ls) failed. The values are %I64d and %I64d.
253810File %d. The number of extents = %I64d, used pages = %I64d, and reserved pages = %I64d.
253910The total number of extents = %I64d, used pages = %I64d, and reserved pages = %I64d in this database.
254010The system cannot self repair this error.
254110DBCC UPDATEUSAGE: Usage counts updated for table ‘%.*ls’ (index ‘%.*ls’, partition %ld):
254210        DATA pages %.*ls: changed from (%I64d) to (%I64d) pages.
254310        USED pages %.*ls: changed from (%I64d) to (%I64d) pages.
254410        RSVD pages %.*ls: changed from (%I64d) to (%I64d) pages.
254510        ROWS count: changed from (%I64d) to (%I64d) rows.
254610Index ‘%.*ls’ on table ‘%.*ls’ is marked as disabled. Rebuild the index to bring it online.
254716Unable to process object ID %ld (object “%.*ls”) because it is a synonym. If the object referenced by the synonym is a table or view, retry the operation using the base object that the synonym references.
254810DBCC: Compaction phase of index ‘%.*ls’ is %d%% complete.
254910DBCC: Defrag phase of index ‘%.*ls’ is %d%% complete.
255016The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because it is being reorganized by another process.
255116The indexes on table “%.*ls” cannot be reorganized because there is already an online index build or rebuild in progress on the table.
255216The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because page level locking is disabled.
255310 Table ‘%.*ls’ will not be available during reorganizing index ‘%.*ls’.  This is because the index reorganization operation performs inside a user transaction and the entire table is exclusively locked.
255416The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because the filegroup is read-only.
255516Cannot move all contents of file “%.*ls” to other places to complete the emptyfile operation.
255616There is insufficient space in the filegroup to complete the emptyfile operation.
255714User ‘%.*ls’ does not have permission to run DBCC %ls for object ‘%.*ls’.
255816%I64d incorrect counts were detected in database ‘%.*ls’.
255916The ‘%ls’ and ‘%ls’ options are not allowed on the same statement.
256016Parameter %d is incorrect for this DBCC statement.
256116Parameter %d is incorrect for this statement.
256216Checking FILESTREAM filegroup “%.*ls” (ID %d) is not supported in DBCC CHECKFILEGROUP.  Specify a filegroup containing user objects with FILESTREAM data instead.
256316DBCC SHRINKFILE for FILESTREAM containers requires EMPTYFILE option and does not allow any other options.
256416DBCC SHRINKFILE for %.*ls is aborted. MEMORY_OPTIMIZED_DATA containers are not supported.
256516DBCC DBREINDEX cannot be used on memory optimized tables.
256614DBCC DBREINDEX cannot be used on system tables.
256714DBCC INDEXDEFRAG cannot be used on system table indexes
256816Page %S_PGID is out of range for this database or is in a log file.
257016Page %S_PGID, slot %d in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type “%.*ls”). Column “%.*ls” value is out of range for data type “%.*ls”.  Update column to a legal value.
257114User ‘%.*ls’ does not have permission to run DBCC %.*ls.
257216DBCC cannot free DLL ‘%.*ls’. The DLL is in use.
257316Could not find table or object ID %.*ls. Check system catalog.
257416Table error: Page %S_PGID is empty in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). This is not permitted at level %d of the B-tree.
257516The Index Allocation Map (IAM) page %S_PGID is pointed to by the next pointer of IAM page %S_PGID in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), but it was not detected in the scan.
257616The Index Allocation Map (IAM) page %S_PGID is pointed to by the previous pointer of IAM page %S_PGID in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), but it was not detected in the scan.
257716Chain sequence numbers are out of order in the Index Allocation Map (IAM) chain for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). Page %S_PGID with sequence number %d points to page %S_PGID with sequence number %d.
257916Table error: Extent %S_PGID in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) is beyond the range of this database.
258016Table ‘%.*ls’ is either a system or temporary table. DBCC CLEANTABLE cannot be applied to a system or temporary table.
258110DBCC cannot free the DLL “%.*ls”. The DLL is not loaded.
258316An incorrect number of parameters was given to the DBCC statement.
258516Cannot find partition number %ld for table “%.*ls”.
258616Cannot find partition number %ld for index “%.*ls”, table “%.*ls”.
258716The invalid partition number %ld was specified.
258816Cannot find partition number %ld for index ID %d, object ID %d.
258916Repair could not fix all errors on the first attempt.
259010User “%.*ls” is modifying bytes %d to %d of page %S_PGID in database “%.*ls”.
259116Cannot find a row in the system catalog with the index ID %d for table “%.*ls”.
259210Repair: The %ls index successfully rebuilt for the object “%.*ls” in database “%.*ls”.
259310There are %I64d rows in %I64d pages for object “%.*ls”.
259410Cannot process rowset ID %I64d of object “%.*ls” (ID %d), index “%.*ls” (ID %d), because it resides on filegroup “%.*ls” (ID %d), which was not checked.
259616The repair statement was not processed. The database cannot be in read-only mode.
259710Ignoring trace flag %d. It is either an invalid trace flag or a trace flag that can only be specified during server startup.
259816Check cannot proceed on any objects belonging to database “%.*ls” because it is currently in recovery.
259916Cannot switch to in row text in table “%.*ls”.
260114Cannot insert duplicate key row in object ‘%.*ls’ with unique index ‘%.*ls’. The duplicate key value is %ls.
262714Violation of %ls constraint ‘%.*ls’. Cannot insert duplicate key in object ‘%.*ls’. The duplicate key value is %ls.
262816String or binary data would be truncated in table ‘%.*ls’, column ‘%.*ls’. Truncated value: ‘%.*ls’.
270016There are too many statements in the batch; the maximum number is %d
270110Database name ‘%.*ls’ ignored, referencing object in tempdb.
270216Database ‘%.*ls’ does not exist.
270316Cannot use duplicate column names in the partition columns list. Column name ‘%.*ls’ appears more than once.
270416Invalid partition scheme ‘%.*ls’ specified.
270516Column names in each table must be unique. Column name ‘%.*ls’ in table ‘%.*ls’ is specified more than once.
270611Table ‘%.*ls’ does not exist.
270716Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it depends on a non-schemabound object.
270916Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it does user or system data access.
271016You are not the owner specified for the object ‘%.*ls’ in this statement (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS or BULK INSERT).
271116The definition of object “%.*ls” in the resource database contains the non-ASCII character “%.*ls”.
271216Database ‘%.*ls’ can not be configured as a distribution database because it has change tracking enabled.
271416There is already an object named ‘%.*ls’ in the database.
271516Column, parameter, or variable #%d: Cannot find data type %.*ls.
271616Column, parameter, or variable #%d: Cannot specify a column width on data type %.*ls.
271715The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed (%d).
271916Upgrade of database “%.*ls” failed because it contains a user named “sys” which is a reserved user or schema name in this version of SQL Server.
272016Cannot schema bind %S_MSG ‘%.*ls’ because it references system object ‘%.*ls’.
272216Xml data type methods are not allowed in expressions in this context.
272410Parameter or variable ‘%.*ls’ has an invalid data type.
272516An online operation cannot be performed for %S_MSG ‘%.*ls’ because the index contains column ‘%.*ls’ of data type text, ntext, image or FILESTREAM. For a non-clustered index, the column could be an include column of the index. For a clustered index, the column could be any column of the table. If DROP_EXISTING is used, the column could be part of a new or old index. The operation must be performed offline.
272616Partition function ‘%.*ls’ uses %d columns which does not match with the number of partition columns used to partition the table or index.
272711Cannot find index ‘%.*ls’.
272816Cannot partition on more than %d columns.
272916Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it is non-deterministic.
273011Cannot create procedure ‘%.*ls’ with a group number of %d because a procedure with the same name and a group number of 1 does not currently exist in the database. Must execute CREATE PROCEDURE ‘%.*ls’;1 first.
273116Column ‘%.*ls’ has invalid width: %d.
273216Error number %ld is invalid. The number must be from %ld through %ld and it cannot be 50000.
273316The %ls data type is invalid for return values.
273516Cannot create primary xml, selective xml or spatial index ‘%.*ls’ on ‘%.*ls’ because PRIMARY KEY constraint contains column(s) of type timestamp.
273816A table can only have one timestamp column. Because table ‘%.*ls’ already has one, the column ‘%.*ls’ cannot be added.
273916The text, ntext, and image data types are invalid for local variables.
274016SET LANGUAGE failed because ‘%.*ls’ is not an official language name or a language alias on this SQL Server.
274116SET DATEFORMAT date order ‘%.*ls’ is invalid.
274216SET DATEFIRST %d is out of range.
274316%ls option requires %S_MSG parameter.
274416Multiple identity columns specified for table ‘%.*ls’. Only one identity column per table is allowed.
274510Process ID %d has raised user error %d, severity %d. SQL Server is terminating this process.
274716Too many substitution parameters for RAISERROR. Cannot exceed %d substitution parameters.
274816Cannot specify %ls data type (parameter %d) as a substitution parameter.
274916Identity column ‘%.*ls’ must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, unencrypted, and constrained to be nonnullable.
275016Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.
275116Column or parameter #%d: Specified column scale %d is greater than the specified precision of %d.
275216Identity column ‘%.*ls’ contains invalid SEED.
275316Identity column ‘%.*ls’ contains invalid INCREMENT.
275416Error severity levels greater than %d can only be specified by members of the sysadmin role, using the WITH LOG option.
275516SET DEADLOCK_PRIORITY option is invalid. Valid options are {HIGH | NORMAL | LOW | [%d … %d] of type integer}.
275616Invalid value %d for state. State value must not be less than %d.
275916CREATE SCHEMA failed due to previous errors.
276016The specified schema name “%.*ls” either does not exist or you do not have permission to use it.
276116The ROWGUIDCOL property can only be specified on the uniqueidentifier data type.
276216sp_setapprole was not invoked correctly. Refer to the documentation for more information.
276616The definition for user-defined data type ‘%.*ls’ has changed.
276715Could not locate statistics ‘%.*ls’ in the system catalogs.
277016The SELECT INTO statement cannot have same source and destination tables.
277216Cannot access temporary tables from within a function.
277316The collation ID is corrupted because the sort order ID %d is not valid.
277416Collation ID %d is invalid.
277516The code page %d is not supported by the server.
277816Only System Administrator can specify %s option for %s command.
277916The %S_MSG ‘%.*ls’ is an auto-drop system object. It cannot be used in queries or DDL.
278016View ‘%.*ls’ is not schemabound.
278216Cannot create table “%.*ls”: A table must have a clustered primary key in order to have XML data type columns.
278516User-defined functions, user-defined aggregates, CLR types, and methods on CLR types are not allowed in expressions in this context.
278616The data type of substitution parameter %d does not match the expected type of the format specification.
278716Invalid format specification: ‘%.*ls’.
278816Synonyms are invalid in a schemabound object or a constraint expression.
278916Must specify a two-part name for %S_MSG ‘%.*ls’ in a schemabound object or a constraint expression.
279016Cannot use a column of type TEXT, NTEXT, or IMAGE in a constraint expression.
279116Could not resolve expression for Schema-bound object or constraint.
279216Cannot specify a sql CLR type in a Schema-bound object or a constraint expression.
279316Specified owner name ‘%.*ls’ either does not exist or you do not have permission to act on its behalf.
279416Message text expects more than the maximum number of arguments (%d).
279516Could not %S_MSG %S_MSG because the new %S_MSG ‘%.*ls’ does not match the FILESTREAM %S_MSG ‘%.*ls’ of the table.
279616Cannot specify database name with $partition in a Schema-bound object, computed column or constraint expression.
279716The default schema does not exist.
279816Cannot create index or statistics ‘%.*ls’ on table ‘%.*ls’ because SQL Server cannot verify that key column ‘%.*ls’ is precise and deterministic. Consider removing column from index or statistics key, marking computed column persisted, or using non-CLR-derived column in key.
279916Cannot create index or statistics ‘%.*ls’ on table ‘%.*ls’ because the computed column ‘%.*ls’ is imprecise and not persisted. Consider removing column from index or statistics key or marking computed column persisted.
280116The definition of object ‘%.*ls’ has changed since it was compiled.
280210SQL Server has encountered %d occurrence(s) of cachestore flush for the ‘%s’ cachestore (part of plan cache) due to ‘DBCC FREEPROCCACHE’ or ‘DBCC FREESYSTEMCACHE’ operations.
280310SQL Server has encountered %d occurrence(s) of cachestore flush for the ‘%s’ cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
280916The request for %S_MSG ‘%.*ls’ failed because ‘%.*ls’ is a %S_MSG object.
281216Could not find stored procedure ‘%.*ls’.
281316%.*ls is not supported on this edition of SQL Server.
281410A possible infinite recompile was detected for SQLHANDLE %hs, PlanHandle %hs, starting offset %d, ending offset %d.  The last recompile reason was %d.
281510A possible infinite recompile was detected for the natively compiled module with ID ‘%d’ in database with ID ‘%d’.
281616The metadata for object with id %d has changed. Retry the statement.
281716‘%.*ls’ is not supported on the ‘%.*ls’ platform.