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
| ErrorCode | Severity | ErrorMessage |
| 2002 | 16 | Cannot create a procedure for replication with group number greater than one. |
| 2003 | 16 | Procedures with a group number cannot have parameters of XML, CLR or encrypted types. Parameter ‘%.*ls’ of procedure ‘%.*ls’ has type ‘%ls’. |
| 2004 | 16 | Procedure ‘%.*ls’ has already been created with group number %d. Create procedure with an unused group number. |
| 2005 | 16 | The table ‘%.*ls’ is unavailable and needs to be rebuilt. Rebuild the table offline. |
| 2007 | 10 | The module ‘%.*ls’ depends on the missing object ‘%.*ls’. The module will still be created; however, it cannot run successfully until the object exists. |
| 2008 | 16 | The object ‘%.*ls’ is not a procedure so you cannot create another procedure under that group name. |
| 2010 | 16 | Cannot perform alter on ‘%.*ls’ because it is an incompatible object type. |
| 2011 | 16 | Index hints within a schema-bound object can be applied only to memory optimized tables. |
| 2013 | 10 | Warning: ‘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. |
| 2014 | 16 | Remote access is not allowed from within a schema-bound object. |
| 2020 | 16 | The 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. |
| 2021 | 16 | The referenced entity ‘%.*ls’ was modified during DDL execution. Please retry the operation. |
| 2022 | 16 | Parsing errors were encountered in the %S_MSG ‘%.*ls’. The dependencies referenced from this object could not be determined. |
| 2023 | 10 | Metadata was not updated for the schema-bound object ‘%ls’. |
| 2101 | 14 | Cannot %S_MSG a server level %S_MSG for user ‘%.*ls’ since there is no login corresponding to the user. |
| 2102 | 16 | Cannot %S_MSG %S_MSG ‘%.*ls’ since there is no user for login ‘%.*ls’ in database ‘%.*ls’. |
| 2103 | 15 | Cannot %S_MSG trigger ‘%.*s’ because its schema is different from the schema of the target table or view. |
| 2104 | 14 | Cannot %S_MSG the %S_MSG ‘%.*ls’, because you do not have permission. |
| 2108 | 15 | Cannot %S_MSG %S_MSG on ‘%.*ls’ as the target is not in the current database. |
| 2110 | 15 | Cannot 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. |
| 2111 | 16 | Cannot %S_MSG trigger ‘%.*ls’ on %S_MSG ‘%.*ls’ because an INSTEAD OF %s trigger already exists on this object. |
| 2112 | 16 | Cannot create trigger ‘%.*ls’ on view ‘%.*ls’ because the view is defined with CHECK OPTION. |
| 2113 | 16 | Cannot %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. |
| 2114 | 16 | Column ‘%.*ls’ cannot be used in an IF UPDATE clause because it is a computed column. |
| 2115 | 16 | Server level event notifications are disabled as the database msdb does not exist. |
| 2116 | 16 | Cannot CREATE EVENT NOTIFICATION to database ‘%.*ls’ because it is not a valid broker database. |
| 2117 | 16 | Cannot %S_MSG INSTEAD OF trigger ‘%.*ls’ on %S_MSG ‘%.*ls’ because the %S_MSG has a FILESTREAM column. |
| 2201 | 16 | %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. |
| 2202 | 16 | %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. |
| 2203 | 16 | %sOnly ‘http://www.w3.org/2001/XMLSchema#decimal?’, ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed as predicates, found ‘%ls’ |
| 2204 | 16 | %sOnly ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed in conditions and with logical operators, found ‘%ls’ |
| 2205 | 16 | %s”%ls” was expected. |
| 2206 | 16 | %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. |
| 2207 | 16 | %sOnly non-document nodes can be inserted. Found “%ls”. |
| 2208 | 16 | %sThe URI that starts with ‘%ls’ is too long. Maximum allowed length is %d characters. |
| 2209 | 16 | %sSyntax error near ‘%ls’ |
| 2210 | 16 | %sHeterogeneous sequences are not allowed: found ‘%ls’ and ‘%ls’ |
| 2211 | 16 | %sSingleton (or empty sequence) required, found operand of type ‘%ls’ |
| 2212 | 16 | %sInvalid source character ‘%c’ (0x%02x) found in an identifier near ‘%ls’. |
| 2213 | 16 | %sCannot atomize/apply data() on expression that contains type ‘%ls’ within inferred type ‘%ls’ |
| 2214 | 16 | %sThe type ‘%ls’ is not an atomic type |
| 2215 | 16 | %sThe value of attribute ‘%ls’ exceeds 4000 characters, the maximum permitted in XML schema documents |
| 2216 | 16 | %sInvalid XPath value in “%ls”. |
| 2217 | 16 | %s’%ls’ or ‘%ls’ expected |
| 2218 | 16 | %sThere is no attribute named ‘@%ls’ |
| 2219 | 16 | %sThere is no attribute named ‘@%ls’ in the type ‘%ls’. |
| 2220 | 16 | %sThere is no attribute named ‘@%ls:%ls’ |
| 2221 | 16 | %sThere is no attribute named ‘@%ls:%ls’ in the type ‘%ls’. |
| 2222 | 16 | %sInvalid source character 0x%02x found in an identifier near ‘%ls’. |
| 2223 | 16 | %sSyntax error near ‘%ls’, expected an identifier. |
| 2225 | 16 | %sA string literal was expected |
| 2226 | 16 | %sThe target of ‘insert’ must be a single node, found ‘%ls’ |
| 2227 | 16 | %sThe variable ‘%ls’ was not found in the scope in which it was referenced. |
| 2228 | 16 | %sThe variable ‘%ls:%ls’ was not found in the scope in which it was referenced. |
| 2229 | 16 | %sThe name “%ls” does not denote a namespace. |
| 2230 | 16 | %sThe name “%ls” has already been defined. |
| 2231 | 16 | %sThe name “%ls” does not denote a defined type. |
| 2232 | 16 | %sThe name “%ls:%ls” does not denote a defined type. |
| 2233 | 16 | %sThe operand of “%ls” has an invalid type. |
| 2234 | 16 | %sThe operator “%ls” cannot be applied to “%ls” and “%ls” operands. |
| 2235 | 16 | %sAn argument list was applied to a non-function term. |
| 2236 | 16 | %sThere are not enough actual arguments in the call to function “%ls”. |
| 2237 | 16 | %sDerivation from anyType by extension is not supported in this release. |
| 2238 | 16 | %sToo many arguments in call to function ‘%ls’ |
| 2240 | 16 | %sThe target of ‘insert into’ must be an element/document node, found ‘%ls’ |
| 2241 | 16 | %sVariable expected: ‘$name’ |
| 2242 | 16 | %sType specification expected. |
| 2243 | 16 | %sRelative path expression used without any context |
| 2247 | 16 | %sThe value is of type “%ls”, which is not a subtype of the expected type “%ls”. |
| 2248 | 16 | %sSyntax error near ‘%ls’, expected ‘as’, ‘into’, ‘before’ or ‘after’. |
| 2249 | 16 | %sThe target of ‘insert before/after’ must be an element/PI/comment/text node, found ‘%ls’ |
| 2256 | 16 | %sSyntax error near ‘%ls’, expected a “node test”. |
| 2258 | 16 | %sThe position may not be specified when inserting an attribute node, found ‘%ls’ |
| 2260 | 16 | %sThere is no element named ‘%ls’ |
| 2261 | 16 | %sThere is no element named ‘%ls’ in the type ‘%ls’. |
| 2262 | 16 | %sThere is no element named ‘%ls:%ls’ |
| 2263 | 16 | %sThere is no element named “%ls:%ls” in the type “%ls”. |
| 2264 | 16 | %sOnly non-document nodes may be deleted, found ‘%ls’ |
| 2266 | 16 | %sExpected end tag ‘%ls:%ls’ |
| 2267 | 16 | %sExpected end tag ‘%ls’ |
| 2268 | 16 | %sEnd tag ‘/%ls:%ls’ has no matching begin tag |
| 2269 | 16 | %sEnd tag ‘/%ls’ has no matching begin tag |
| 2270 | 16 | %sDuplicate attribute ‘%ls:%ls’ |
| 2271 | 16 | %sDuplicate attribute ‘%ls’ |
| 2272 | 16 | %s’?>’ expected |
| 2273 | 16 | %sUnterminated CDATA section |
| 2274 | 16 | %sUnterminated string constant (started on line %u) |
| 2275 | 16 | %sUnterminated XML declaration |
| 2276 | 16 | %sDerivation from ‘QName’ by restriction is not supported in this release |
| 2277 | 16 | %sA tag name may not contain the character ‘%c’ |
| 2278 | 16 | %sA tag name may not start with the character ‘%c’ |
| 2279 | 16 | %sA name/token may not start with the character ‘%c’ |
| 2280 | 16 | %s<! was not followed by a valid construct |
| 2281 | 16 | %sCannot construct DTDs in XQuery |
| 2282 | 16 | %sInvalid entity reference |
| 2283 | 16 | %sThe character ‘%c’ may not be part of an entity reference |
| 2284 | 16 | %sThe namespace prefix ‘%ls’ has not been defined |
| 2285 | 16 | %sInvalid numeric entity reference |
| 2291 | 16 | %sNo root element was found. |
| 2292 | 16 | %sWhen a type with simple content restricts a type with mixed content, it must have an embedded simple type definition. Location: ‘%ls’. |
| 2293 | 16 | %sChoice cannot be empty unless minOccurs is 0. Location: ‘%ls’. |
| 2294 | 16 | %s’xml’ is not allowed as a processing instruction target. |
| 2297 | 16 | %sElement <%ls> is not valid at location ‘%ls’. |
| 2298 | 16 | %sAttribute ‘%ls’ is not valid at location ‘%ls’. |
| 2299 | 16 | %sRequired attribute “%ls” of XSD element “%ls” is missing. |
| 2300 | 16 | %sRequired sub-element “%ls” of XSD element “%ls” is missing. |
| 2301 | 16 | %sThe element “%ls” has already been defined. |
| 2302 | 16 | %sThe name “%ls” has already been defined in this scope. |
| 2305 | 16 | %sElement or attribute type specified more than once. Location: ‘%ls’. |
| 2306 | 16 | %sThe qualified name “%ls” was found in a context where only NCName is allowed. |
| 2307 | 16 | %sReference to an undefined name ‘%ls’ |
| 2308 | 16 | %sReference to an undefined name ‘%ls’ within namespace ‘%ls’ |
| 2309 | 16 | %sThe value of “%ls” is not a valid number. |
| 2310 | 16 | %sThe attribute “%ls” is declared more than once. |
| 2311 | 16 | %sThe attribute “%ls” is declared more than once within “%ls”. |
| 2312 | 16 | %sThe value of attribute ‘%ls’ does not conform to the type definition ‘http://www.w3.org/2001/XMLSchema#%ls’: ‘%ls’. |
| 2313 | 16 | %sThe attribute “%ls” cannot have a value of “%ls”. |
| 2314 | 16 | %sThe attribute “%ls” cannot have a negative value. |
| 2315 | 16 | %sThe attribute “%ls” should have a string value. |
| 2316 | 16 | %sThe required ‘base’ attribute is missing. Location: ‘%ls’. |
| 2317 | 16 | %sThe base type “%ls” defined on XSD element “%ls” is not a simple type. |
| 2319 | 16 | %sThis type may not have a ‘%ls’ facet. Location: ‘%ls’. |
| 2320 | 16 | %sDuplicate facet ‘%ls’ found at location ‘%ls’. |
| 2321 | 16 | %sFacets cannot follow attribute declarations. Found facet ‘%ls’ at location ‘%ls’. |
| 2322 | 16 | %sThe element type is not a subclass of the substitution group’s head |
| 2323 | 16 | %sThe end tag ‘%ls’ doesn’t match opening tag ‘%ls’ from line %u |
| 2324 | 16 | %sThe end tag ‘%ls:%ls’ doesn’t match opening tag ‘%ls’ from line %u |
| 2325 | 16 | %sThe end tag ‘%ls’ doesn’t match opening tag ‘%ls:%ls’ from line %u |
| 2326 | 16 | %sThe end tag ‘%ls:%ls’ doesn’t match opening tag ‘%ls:%ls’ from line %u |
| 2327 | 16 | %sThe content or definition of <%ls> is missing. |
| 2328 | 16 | %sSchema namespace ‘%ls’ doesn’t match <include> directive’s ‘%ls’ |
| 2329 | 16 | %sThe string “%ls” is not a valid time duration value. |
| 2331 | 16 | %sRedefinition has to have itself as base type. Location: ‘%ls’. |
| 2332 | 16 | %s’%ls’ may not be used with an ’empty’ operand |
| 2333 | 16 | %sInvalid source character 0x%02x |
| 2334 | 16 | %sInvalid source character ‘%c’ (0x%02x) |
| 2335 | 16 | %sNewline in character/string constant |
| 2336 | 16 | %s’%c’ is not a valid octal digit (numbers starting with ‘0’ are implicitly octal) |
| 2337 | 16 | %sThe target of ‘replace’ must be at most one node, found ‘%ls’ |
| 2338 | 16 | %sThe second ‘replace’ operand must contain only nodes, found ‘%ls’ |
| 2339 | 16 | %sEither a memberType attribute or a simpleType child must be present. Location: ‘%ls’. |
| 2340 | 16 | %sComment started on line %u has no end |
| 2341 | 16 | %sExpected hex character code following ‘\\x’ |
| 2342 | 16 | %sInvalid numeric constant. |
| 2343 | 16 | %sUnterminated text section – missing ` |
| 2348 | 16 | %sA namespace URI should contain at least one non-whitespace character. |
| 2349 | 16 | %sAttempt to redefine namespace prefix ‘%ls’ |
| 2350 | 16 | %sInvalid XML element content |
| 2351 | 16 | %sExpected ‘first’ or ‘last’ |
| 2353 | 16 | %s’to’ or ‘insert’ or ‘delete’ expected |
| 2354 | 16 | %sInvalid source character encoding |
| 2355 | 16 | %s’else’ expected |
| 2356 | 16 | %sThe target of ‘replace value of’ must be a non-metadata attribute or an element with simple typed content, found ‘%ls’ |
| 2357 | 16 | %sA document node may only be replaced with another document node, found ‘%ls’ |
| 2358 | 16 | %sDerivation with both a ‘base’ attribute and an embedded type definition is not supported in this release. Location: ‘%ls’. |
| 2359 | 16 | %sThe target of ‘%ls’ may not be a constructed node |
| 2360 | 16 | %sCannot have both a ‘name’ and ‘ref’ attribute. Location: ‘%ls’. |
| 2361 | 16 | %sThe base type of an XSD extension or restriction type must be a simple type. |
| 2362 | 16 | %sXSD schema too complex |
| 2363 | 16 | %sXQuery too complex |
| 2364 | 16 | %sCannot implicitly convert from ‘%ls’ to ‘%ls’ |
| 2365 | 16 | %sCannot explicitly convert from ‘%ls’ to ‘%ls’ |
| 2366 | 16 | %s”%ls” has a circular definition. |
| 2367 | 16 | %sThe item type of an XSD list type must be a simple type. Location: ‘%ls’. |
| 2368 | 16 | %sCannot have element content in a complex type with simple content. Location: ‘%ls’. |
| 2369 | 16 | %sCannot have more than one group/sequence/choice/all within a restriction or extension. Location: ‘%ls’. |
| 2370 | 16 | %sNo more tokens expected at the end of the XQuery expression. Found ‘%ls’. |
| 2371 | 16 | %s’%ls’ can only be used within a predicate or XPath selector |
| 2372 | 16 | %sMetadata attribute ‘@%ls:%ls’ may not be used with ‘%ls’ |
| 2373 | 16 | %s%ls is not supported with constructed XML |
| 2374 | 16 | %sA node or set of nodes is required for %ls |
| 2375 | 16 | %sAggregate function ‘%ls’ expects a sequence argument |
| 2376 | 16 | %sOperand of a single numeric type expected |
| 2377 | 16 | %sResult of ‘%ls’ expression is statically ’empty’ |
| 2378 | 16 | %sExpected XML schema document |
| 2379 | 16 | %sThe name specified is not a valid XML name :’%ls’ |
| 2380 | 16 | %sMixed content is not allowed at location ‘%ls’. |
| 2382 | 16 | %sInvalid combination of minOccurs and maxOccurs values, minOccurs has to be less than or equal to maxOccurs. Location: ‘%ls’. |
| 2383 | 16 | %sInvalid value ‘%ls’ for the %ls attribute. The value has to be between 0 and %ld. |
| 2384 | 16 | %sInvalid element occurrence, element ‘%ls’ was found multiple times in the context of element ‘%ls’ |
| 2385 | 16 | Invalid target namespace specified |
| 2386 | 16 | %sThe value of ‘%ls’ facet is outside of the allowed range |
| 2387 | 16 | %sCannot have both ‘type’ and ‘ref’ attributes. Location: ‘%ls’. |
| 2388 | 16 | %sInvalid element occurrence, element ‘%ls’ has to appear first in the context of ‘%ls’ |
| 2389 | 16 | %s’%ls’ requires a singleton (or empty sequence), found operand of type ‘%ls’ |
| 2390 | 16 | %sTop-level %s nodes are not supported |
| 2391 | 16 | %sRedefining XSD schemas is not supported |
| 2392 | 16 | %s’%ls::’ is not a valid axis |
| 2393 | 16 | %sEither an itemType attribute or a simpleType child must be present. Location: ‘%ls’. |
| 2394 | 16 | %sThere is no function ‘%ls()’ |
| 2395 | 16 | %sThere is no function ‘%ls:%ls()’ |
| 2396 | 16 | %sAttribute may not appear outside of an element |
| 2397 | 16 | %sIdentifiers may not contain more than %u characters |
| 2398 | 16 | %sDuplicate id value found: ‘%ls’ |
| 2399 | 16 | %sAn attribute cannot have a value of type ‘%ls’, a simple type was expected |
| 2431 | 10 | Error [%d, %d, %d] occurred while attempting to deallocate workfile extent with extent ID [%d:%d]. |
| 2501 | 16 | Cannot find a table or object with the name “%.*ls”. Check the system catalog. |
| 2502 | 16 | Memory object list dump failed due to temporary inconsistency in the memory object structure. Please try again. |
| 2503 | 10 | Successfully deleted the physical file ‘%ls’. |
| 2504 | 16 | Could not delete the physical file ‘%ls’. The DeleteFile system function returned error %ls. |
| 2505 | 16 | The device ‘%.*ls’ does not exist. Use sys.backup_devices to show available devices. |
| 2506 | 16 | Could not find a table or object name ‘%.*ls’ in database ‘%.*ls’. |
| 2507 | 16 | The CONCAT_NULL_YIELDS_NULL option must be set to ON to run DBCC CHECKCONSTRAINTS. |
| 2508 | 16 | The %.*ls count for object “%.*ls”, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) is incorrect. Run DBCC UPDATEUSAGE. |
| 2509 | 16 | DBCC CHECKCONSTRAINTS failed due to an internal query error. Please run DBCC CHECKDATABASE to ensure your data consistency. |
| 2510 | 16 | DBCC %ls error: %ls. |
| 2511 | 16 | Table 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. |
| 2512 | 16 | Table 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. |
| 2513 | 16 | DBCC DBREINDEX cannot be used on memory optimized tables. |
| 2514 | 16 | A DBCC PAGE error has occurred: %ls. |
| 2515 | 16 | The 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. |
| 2516 | 16 | Repair 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. |
| 2517 | 16 | Bulk-logging has been turned on for database %.*ls. To ensure that all data has been secured, run backup log operations again. |
| 2518 | 10 | Object ID %ld (object “%.*ls”): Computed columns and CLR types cannot be checked for this object because the common language runtime (CLR) is disabled. |
| 2519 | 10 | Computed columns and CLR types cannot be checked for object ID %ld (object “%.*ls”) because the internal expression evaluator could not be initialized. |
| 2520 | 16 | Could 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. |
| 2521 | 16 | Could 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. |
| 2522 | 16 | Unable to process index %.*ls of table %.*ls because filegroup %.*ls is invalid. |
| 2523 | 16 | Filegroup %.*ls is invalid. |
| 2524 | 16 | Cannot 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. |
| 2525 | 16 | Database file %.*ls is offline. |
| 2526 | 16 | Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options. |
| 2527 | 16 | Unable to process index %.*ls of table %.*ls because filegroup %.*ls is offline. |
| 2528 | 10 | DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
| 2529 | 16 | Filegroup %.*ls is offline. |
| 2530 | 16 | The index “%.*ls” on table “%.*ls” is disabled. |
| 2531 | 16 | Table 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. |
| 2532 | 16 | One or more WITH options specified are not valid for this command. |
| 2533 | 16 | Table 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. |
| 2534 | 16 | Table 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. |
| 2536 | 10 | DBCC results for ‘%.*ls’. |
| 2537 | 16 | Table 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. |
| 2538 | 10 | File %d. The number of extents = %I64d, used pages = %I64d, and reserved pages = %I64d. |
| 2539 | 10 | The total number of extents = %I64d, used pages = %I64d, and reserved pages = %I64d in this database. |
| 2540 | 10 | The system cannot self repair this error. |
| 2541 | 10 | DBCC UPDATEUSAGE: Usage counts updated for table ‘%.*ls’ (index ‘%.*ls’, partition %ld): |
| 2542 | 10 | DATA pages %.*ls: changed from (%I64d) to (%I64d) pages. |
| 2543 | 10 | USED pages %.*ls: changed from (%I64d) to (%I64d) pages. |
| 2544 | 10 | RSVD pages %.*ls: changed from (%I64d) to (%I64d) pages. |
| 2545 | 10 | ROWS count: changed from (%I64d) to (%I64d) rows. |
| 2546 | 10 | Index ‘%.*ls’ on table ‘%.*ls’ is marked as disabled. Rebuild the index to bring it online. |
| 2547 | 16 | Unable 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. |
| 2548 | 10 | DBCC: Compaction phase of index ‘%.*ls’ is %d%% complete. |
| 2549 | 10 | DBCC: Defrag phase of index ‘%.*ls’ is %d%% complete. |
| 2550 | 16 | The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because it is being reorganized by another process. |
| 2551 | 16 | The indexes on table “%.*ls” cannot be reorganized because there is already an online index build or rebuild in progress on the table. |
| 2552 | 16 | The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because page level locking is disabled. |
| 2553 | 10 | 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. |
| 2554 | 16 | The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because the filegroup is read-only. |
| 2555 | 16 | Cannot move all contents of file “%.*ls” to other places to complete the emptyfile operation. |
| 2556 | 16 | There is insufficient space in the filegroup to complete the emptyfile operation. |
| 2557 | 14 | User ‘%.*ls’ does not have permission to run DBCC %ls for object ‘%.*ls’. |
| 2558 | 16 | %I64d incorrect counts were detected in database ‘%.*ls’. |
| 2559 | 16 | The ‘%ls’ and ‘%ls’ options are not allowed on the same statement. |
| 2560 | 16 | Parameter %d is incorrect for this DBCC statement. |
| 2561 | 16 | Parameter %d is incorrect for this statement. |
| 2562 | 16 | Checking FILESTREAM filegroup “%.*ls” (ID %d) is not supported in DBCC CHECKFILEGROUP. Specify a filegroup containing user objects with FILESTREAM data instead. |
| 2563 | 16 | DBCC SHRINKFILE for FILESTREAM containers requires EMPTYFILE option and does not allow any other options. |
| 2564 | 16 | DBCC SHRINKFILE for %.*ls is aborted. MEMORY_OPTIMIZED_DATA containers are not supported. |
| 2565 | 16 | DBCC DBREINDEX cannot be used on memory optimized tables. |
| 2566 | 14 | DBCC DBREINDEX cannot be used on system tables. |
| 2567 | 14 | DBCC INDEXDEFRAG cannot be used on system table indexes |
| 2568 | 16 | Page %S_PGID is out of range for this database or is in a log file. |
| 2570 | 16 | Page %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. |
| 2571 | 14 | User ‘%.*ls’ does not have permission to run DBCC %.*ls. |
| 2572 | 16 | DBCC cannot free DLL ‘%.*ls’. The DLL is in use. |
| 2573 | 16 | Could not find table or object ID %.*ls. Check system catalog. |
| 2574 | 16 | Table 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. |
| 2575 | 16 | The 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. |
| 2576 | 16 | The 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. |
| 2577 | 16 | Chain 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. |
| 2579 | 16 | Table 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. |
| 2580 | 16 | Table ‘%.*ls’ is either a system or temporary table. DBCC CLEANTABLE cannot be applied to a system or temporary table. |
| 2581 | 10 | DBCC cannot free the DLL “%.*ls”. The DLL is not loaded. |
| 2583 | 16 | An incorrect number of parameters was given to the DBCC statement. |
| 2585 | 16 | Cannot find partition number %ld for table “%.*ls”. |
| 2586 | 16 | Cannot find partition number %ld for index “%.*ls”, table “%.*ls”. |
| 2587 | 16 | The invalid partition number %ld was specified. |
| 2588 | 16 | Cannot find partition number %ld for index ID %d, object ID %d. |
| 2589 | 16 | Repair could not fix all errors on the first attempt. |
| 2590 | 10 | User “%.*ls” is modifying bytes %d to %d of page %S_PGID in database “%.*ls”. |
| 2591 | 16 | Cannot find a row in the system catalog with the index ID %d for table “%.*ls”. |
| 2592 | 10 | Repair: The %ls index successfully rebuilt for the object “%.*ls” in database “%.*ls”. |
| 2593 | 10 | There are %I64d rows in %I64d pages for object “%.*ls”. |
| 2594 | 10 | Cannot 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. |
| 2596 | 16 | The repair statement was not processed. The database cannot be in read-only mode. |
| 2597 | 10 | Ignoring trace flag %d. It is either an invalid trace flag or a trace flag that can only be specified during server startup. |
| 2598 | 16 | Check cannot proceed on any objects belonging to database “%.*ls” because it is currently in recovery. |
| 2599 | 16 | Cannot switch to in row text in table “%.*ls”. |
| 2601 | 14 | Cannot insert duplicate key row in object ‘%.*ls’ with unique index ‘%.*ls’. The duplicate key value is %ls. |
| 2627 | 14 | Violation of %ls constraint ‘%.*ls’. Cannot insert duplicate key in object ‘%.*ls’. The duplicate key value is %ls. |
| 2628 | 16 | String or binary data would be truncated in table ‘%.*ls’, column ‘%.*ls’. Truncated value: ‘%.*ls’. |
| 2700 | 16 | There are too many statements in the batch; the maximum number is %d |
| 2701 | 10 | Database name ‘%.*ls’ ignored, referencing object in tempdb. |
| 2702 | 16 | Database ‘%.*ls’ does not exist. |
| 2703 | 16 | Cannot use duplicate column names in the partition columns list. Column name ‘%.*ls’ appears more than once. |
| 2704 | 16 | Invalid partition scheme ‘%.*ls’ specified. |
| 2705 | 16 | Column names in each table must be unique. Column name ‘%.*ls’ in table ‘%.*ls’ is specified more than once. |
| 2706 | 11 | Table ‘%.*ls’ does not exist. |
| 2707 | 16 | Column ‘%.*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. |
| 2709 | 16 | Column ‘%.*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. |
| 2710 | 16 | You are not the owner specified for the object ‘%.*ls’ in this statement (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS or BULK INSERT). |
| 2711 | 16 | The definition of object “%.*ls” in the resource database contains the non-ASCII character “%.*ls”. |
| 2712 | 16 | Database ‘%.*ls’ can not be configured as a distribution database because it has change tracking enabled. |
| 2714 | 16 | There is already an object named ‘%.*ls’ in the database. |
| 2715 | 16 | Column, parameter, or variable #%d: Cannot find data type %.*ls. |
| 2716 | 16 | Column, parameter, or variable #%d: Cannot specify a column width on data type %.*ls. |
| 2717 | 15 | The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed (%d). |
| 2719 | 16 | Upgrade 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. |
| 2720 | 16 | Cannot schema bind %S_MSG ‘%.*ls’ because it references system object ‘%.*ls’. |
| 2722 | 16 | Xml data type methods are not allowed in expressions in this context. |
| 2724 | 10 | Parameter or variable ‘%.*ls’ has an invalid data type. |
| 2725 | 16 | An 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. |
| 2726 | 16 | Partition function ‘%.*ls’ uses %d columns which does not match with the number of partition columns used to partition the table or index. |
| 2727 | 11 | Cannot find index ‘%.*ls’. |
| 2728 | 16 | Cannot partition on more than %d columns. |
| 2729 | 16 | Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it is non-deterministic. |
| 2730 | 11 | Cannot 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. |
| 2731 | 16 | Column ‘%.*ls’ has invalid width: %d. |
| 2732 | 16 | Error number %ld is invalid. The number must be from %ld through %ld and it cannot be 50000. |
| 2733 | 16 | The %ls data type is invalid for return values. |
| 2735 | 16 | Cannot create primary xml, selective xml or spatial index ‘%.*ls’ on ‘%.*ls’ because PRIMARY KEY constraint contains column(s) of type timestamp. |
| 2738 | 16 | A table can only have one timestamp column. Because table ‘%.*ls’ already has one, the column ‘%.*ls’ cannot be added. |
| 2739 | 16 | The text, ntext, and image data types are invalid for local variables. |
| 2740 | 16 | SET LANGUAGE failed because ‘%.*ls’ is not an official language name or a language alias on this SQL Server. |
| 2741 | 16 | SET DATEFORMAT date order ‘%.*ls’ is invalid. |
| 2742 | 16 | SET DATEFIRST %d is out of range. |
| 2743 | 16 | %ls option requires %S_MSG parameter. |
| 2744 | 16 | Multiple identity columns specified for table ‘%.*ls’. Only one identity column per table is allowed. |
| 2745 | 10 | Process ID %d has raised user error %d, severity %d. SQL Server is terminating this process. |
| 2747 | 16 | Too many substitution parameters for RAISERROR. Cannot exceed %d substitution parameters. |
| 2748 | 16 | Cannot specify %ls data type (parameter %d) as a substitution parameter. |
| 2749 | 16 | Identity 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. |
| 2750 | 16 | Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d. |
| 2751 | 16 | Column or parameter #%d: Specified column scale %d is greater than the specified precision of %d. |
| 2752 | 16 | Identity column ‘%.*ls’ contains invalid SEED. |
| 2753 | 16 | Identity column ‘%.*ls’ contains invalid INCREMENT. |
| 2754 | 16 | Error severity levels greater than %d can only be specified by members of the sysadmin role, using the WITH LOG option. |
| 2755 | 16 | SET DEADLOCK_PRIORITY option is invalid. Valid options are {HIGH | NORMAL | LOW | [%d … %d] of type integer}. |
| 2756 | 16 | Invalid value %d for state. State value must not be less than %d. |
| 2759 | 16 | CREATE SCHEMA failed due to previous errors. |
| 2760 | 16 | The specified schema name “%.*ls” either does not exist or you do not have permission to use it. |
| 2761 | 16 | The ROWGUIDCOL property can only be specified on the uniqueidentifier data type. |
| 2762 | 16 | sp_setapprole was not invoked correctly. Refer to the documentation for more information. |
| 2766 | 16 | The definition for user-defined data type ‘%.*ls’ has changed. |
| 2767 | 15 | Could not locate statistics ‘%.*ls’ in the system catalogs. |
| 2770 | 16 | The SELECT INTO statement cannot have same source and destination tables. |
| 2772 | 16 | Cannot access temporary tables from within a function. |
| 2773 | 16 | The collation ID is corrupted because the sort order ID %d is not valid. |
| 2774 | 16 | Collation ID %d is invalid. |
| 2775 | 16 | The code page %d is not supported by the server. |
| 2778 | 16 | Only System Administrator can specify %s option for %s command. |
| 2779 | 16 | The %S_MSG ‘%.*ls’ is an auto-drop system object. It cannot be used in queries or DDL. |
| 2780 | 16 | View ‘%.*ls’ is not schemabound. |
| 2782 | 16 | Cannot create table “%.*ls”: A table must have a clustered primary key in order to have XML data type columns. |
| 2785 | 16 | User-defined functions, user-defined aggregates, CLR types, and methods on CLR types are not allowed in expressions in this context. |
| 2786 | 16 | The data type of substitution parameter %d does not match the expected type of the format specification. |
| 2787 | 16 | Invalid format specification: ‘%.*ls’. |
| 2788 | 16 | Synonyms are invalid in a schemabound object or a constraint expression. |
| 2789 | 16 | Must specify a two-part name for %S_MSG ‘%.*ls’ in a schemabound object or a constraint expression. |
| 2790 | 16 | Cannot use a column of type TEXT, NTEXT, or IMAGE in a constraint expression. |
| 2791 | 16 | Could not resolve expression for Schema-bound object or constraint. |
| 2792 | 16 | Cannot specify a sql CLR type in a Schema-bound object or a constraint expression. |
| 2793 | 16 | Specified owner name ‘%.*ls’ either does not exist or you do not have permission to act on its behalf. |
| 2794 | 16 | Message text expects more than the maximum number of arguments (%d). |
| 2795 | 16 | Could not %S_MSG %S_MSG because the new %S_MSG ‘%.*ls’ does not match the FILESTREAM %S_MSG ‘%.*ls’ of the table. |
| 2796 | 16 | Cannot specify database name with $partition in a Schema-bound object, computed column or constraint expression. |
| 2797 | 16 | The default schema does not exist. |
| 2798 | 16 | Cannot 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. |
| 2799 | 16 | Cannot 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. |
| 2801 | 16 | The definition of object ‘%.*ls’ has changed since it was compiled. |
| 2802 | 10 | SQL 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. |
| 2803 | 10 | SQL 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. |
| 2809 | 16 | The request for %S_MSG ‘%.*ls’ failed because ‘%.*ls’ is a %S_MSG object. |
| 2812 | 16 | Could not find stored procedure ‘%.*ls’. |
| 2813 | 16 | %.*ls is not supported on this edition of SQL Server. |
| 2814 | 10 | A possible infinite recompile was detected for SQLHANDLE %hs, PlanHandle %hs, starting offset %d, ending offset %d. The last recompile reason was %d. |
| 2815 | 10 | A possible infinite recompile was detected for the natively compiled module with ID ‘%d’ in database with ID ‘%d’. |
| 2816 | 16 | The metadata for object with id %d has changed. Retry the statement. |
| 2817 | 16 | ‘%.*ls’ is not supported on the ‘%.*ls’ platform. |
