SQL Server error messages list 2000 to 3000

SQL Server error messages list 2000 to 3000.

Following is the list of error messages for sql server (2000 to 3000):

error severity description
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 or CLR 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.
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 cannot be specified within a schema-bound object.
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” do not include references to 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, ensu
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
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 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
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.
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.
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 (%hs) 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.
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.
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.
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, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type. For a non-clustered index, the column could be an in
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 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 statement 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, 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. Valid range is from %d to %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-de
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 18 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.

sql server error list 2000 to 3000
sql server error list error codes 2000 to 3000
sql server error numbers 2000 to 3000
sql server error list 2005 2000 to 3000
sql server error list 2008 2000 to 3000
sql server 2008 error message list 2000 to 3000
sql server errors logs
sql server errors list table

(Visited 267 times, 1 visits today)