Errors 2000 - 2999

Error Severity Description
2001 10 Cannot use duplicate parameter names. Parameter name '%.*ls' listed more than once.
2004 16 Procedure '%.*ls' has already been created with group number %d. Create procedure with an unused group number.
2007 11 Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object '%.*ls'. The stored procedure will still be created.
2008 16 The object '%.*ls' is not a procedure so you cannot create another procedure under that group name.
2009 10 Procedure '%.*ls' was created despite delayed name resolution warnings (if any).
2010 16 Cannot use ALTER %ls with %.*ls because %.*ls is a %S_MSG.
2106 11 Cannot create a trigger on table '%.*ls', because this table does not exist in database '%.*ls'.
2108 16 Cannot create a trigger on table '%.*ls' because you can only create a trigger on a table in the current database.
2109 16 Cannot create a trigger on table '%.*ls' that accesses 'inserted' or 'deleted' because the table was created with the no_log option.
2110 16 Cannot alter trigger '%.*ls' for table '%.*ls' because this trigger does not belong to this table.
2501 16 Could not find table named '%.*ls'. Check sysobjects.
2502 16 Could not start transaction.
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 sp_helpdevice to show available devices.
2511 16 Table Corrupt: Object ID %d, Index ID %d. Keys out of order on page %S_PGID, slots %d and %d.
2513 16 Table Corrupt: Object ID %ld (object '%.*ls') does not match between '%.*ls' and '%.*ls'.
2514 16 Table Corrupt: Data type %ld (type '%.*ls') does not match between '%.*ls' and '%.*ls'.
2520 16 Could not find database '%.*ls'. Check sysdatabases.
2521 16 Could not find database ID %d. Check sysdatabases.
2526 16 Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.
2528 10 DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2532 16 DBCC SHRINKFILE could not shrink file %ls. Log files are not supported.
2535 16 Table Corrupt: Page %S_PGID is allocated to object ID %d, index ID %d, not to object ID %d, index ID %d found in page header.
2536 10 DBCC results for '%.*ls'.
2538 10 Allocation page %S_PGID. Number of extents = %ld, used pages = %ld, referenced pages = %ld.
2539 10 Total number of extents = %ld, used pages = %ld, referenced pages = %ld in this database.
2540 10 The system cannot self repair this error.
2541 10 DBCC UPDATEUSAGE: sysindexes row updated for table '%.*ls' (index ID %ld):
2542 10 DATA pages: Changed from (%ld) to (%ld) pages.
2543 10 USED pages: Changed from (%ld) to (%ld) pages.
2544 10 RSVD pages: Changed from (%ld) to (%ld) pages.
2545 10 ROWS count: Changed from (%I64d) to (%I64d) rows.
2557 16 Only the owner of object '%.*ls' can run DBCC %ls on it.
2560 16 Parameter %d is incorrect for this DBCC statement.
2562 16 '%ls' cannot access object '%.*ls' because it is not a table.
2566 14 DBCC DBREINDEX cannot be used on system tables.
2568 16 Page %S_PGID is out of range for this database or is in a log file.
2571 10 Only members of the sysadmin role can use the DBCC statement %.*ls.
2573 16 Database '%.*ls' is not marked suspect. You cannot drop it with DBCC.
2574 10 Object ID %d, index ID %d: Page %S_PGID is empty. This is not permitted at level %d of the B-tree.
2583 16 An incorrect number of parameters was given to the DBCC statement.
2588 16 Page %S_PGID was expected to be the first page of a text, ntext, or image value.
2591 16 Could not find row in sysindexes with index ID %d for table '%.*ls'.
2592 10 %ls index successfully restored for object '%.*ls' in database '%.*ls'.
2593 10 There are %I64d rows in %ld pages for object '%.*ls'.
2594 16 Invalid index ID (%d) specified.
2595 16 Database '%.*ls' must be set to single user mode before executing this statement.
2597 16 The database is not open. Execute a 'USE %.*ls' statement and rerun the DBCC statement.
2598 16 Clustered indexes on sysobjects and sysindexes cannot be re-created.
2601 14 Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.
2603 21 No space left on logical page %S_PGID of index ID %d for object '%.*ls' when inserting row on an index page. This situation should have been handled while traversing the index.
2617 20 Buffer holding logical page %S_PGID not found in keep pool in SDES for object '%.*ls'. Contact Technical Support.
2624 21 Could not insert into table %S_DES because row length %d is less than the minimum length %d.
2627 14 Violation of %ls constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'.
2701 10 Database name '%.*ls' ignored, referencing object in tempdb.
2702 16 Database '%.*ls' does not exist.
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.
2710 16 You are not the owner specified for the object '%.*ls' in this statement (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS or BULK INSERT).
2714 16 There is already an object named '%.*ls' in the database.
2715 16 Column or parameter #%d: Cannot find data type %.*ls.
2716 16 Column or parameter #%d: Cannot specify a column width on data type %.*ls.
2717 16 Column or parameter #%d: Specified column width too large for data type %.*ls.
2718 16 Column or parameter #%d: Cannot specify null values on a column of data type bit.
2721 11 Could not find a default segment to create the table on. Ask your system administrator to specify a default segment in syssegments.
2724 10 Parameter '%.*ls' has an invalid data type.
2727 11 Cannot find index '%.*ls'.
2729 16 Procedure '%.*ls' group number 1 already exists in the database. Choose another procedure name.
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.
2732 16 User error number %ld is invalid. The number must be between %ld and %ld.
2734 16 The user name '%.*ls' does not exist in sysusers.
2736 16 Owner name specified is a group name. Objects cannot be owned by groups.
2737 16 Message passed to %hs must be of type char, varchar, nchar, or nvarchar.
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.
2746 16 Cannot specify user error format string with a length exceeding %d bytes.
2747 16 Too many substitution parameters for RAISERROR. Cannot exceed %d substitution parameters.
2748 16 Cannot specify %ls data type (RAISERROR parameter %d) as a substitution parameter for RAISERRROR.
2749 16 Identity column '%.*ls' must be of data type int, smallint, tinyint, or decimal or numeric with 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 '%.*ls' is invalid.
2756 16 Invalid value %d for state. Valid range is from %d to %d.
2757 16 RAISERROR failed due to invalid parameter substitution(s) for error %d, severity %d, state %d.
2758 16 %hs could not locate entry for error %d in sysmessages.
2759 0 CREATE SCHEMA failed due to previous errors.
2760 16 Specified owner 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.
2763 16 Could not find application role '%.*ls'.
2764 16 Incorrect password supplied for application role '%.*ls'.
2765 15 Could not locate statistics for column '%.*ls' in the system catalogs.
2766 16 The definition for user-defined data type '%.*ls' has changed.
2767 15 Could not locate statistics '%.*ls' in the system catalogs.
2768 15 Statistics for %ls '%.*ls'.
2769 15 Column '%.*ls'. Cannot create statistics on a column of data type %ls.
2770 16 The SELECT INTO statement cannot have same source and destination tables.
2771 16 Cannot create statistics on table '%.*ls'. This table is a virtual system table.
2809 18 The request for %S_MSG '%.*ls' failed because '%.*ls' is a %S_MSG object.
2812 16 Could not find stored procedure '%.*ls'.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.