Chapter 12 - System Error Messages

error

int

Unique error number

dlevel

smallint

Reserved. For internal use only

mslangid

smallint

System message group ID

%d, %ld, or %D

Decimal integer

%ls or %.*ls

Character string

%c

Single character

1

10

Version date of last upgrade: 10/11/90.

102

15

Incorrect syntax near '%.*ls'.

104

15

ORDER BY items must appear in the select list if the statement contains a UNION operator.

106

16

Too many table names in the query. The maximum allowable is %d.

108

15

The ORDER BY position number %ld is out of range of the number of items in the select list.

110

15

There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

112

15

Variables are not allowed in the %ls statement.

114

15

Browse mode is invalid for a statement that assigns values to a variable.

117

15

The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.

119

15

Must pass parameter number %d and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.

121

15

The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.

124

15

CREATE PROCEDURE contains no statements.

128

15

The name '%.*ls' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

130

16

Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

132

15

The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.

134

15

The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.

136

15

Cannot use a CONTINUE statement outside the scope of a WHILE statement.

138

15

Correlation clause in a subquery not permitted.

140

15

Can only use IF UPDATE within a CREATE TRIGGER statement.

142

15

Incorrect syntax for definition of the '%ls' constraint.

144

15

Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.

146

15

Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.

148

15

Incorrect time syntax in time string '%.*ls' used with WAITFOR.

150

15

Both terms of an outer join must contain columns.

153

15

Invalid usage of the option %.*ls in the %ls statement.

155

15

'%.*ls' is not a recognized %ls option.

157

15

An aggregate may not appear in the set list of an UPDATE statement.

160

15

Rule does not contain a variable.

163

15

The compute by list does not match the order by list.

165

16

Privilege %ls may not be granted or revoked.

167

16

Cannot create a trigger on a temporary object.

169

15

A column has been specified more than once in the order by list. Columns in the order by list must be unique.

171

15

Cannot use SELECT INTO in browse mode.

173

15

The definition for column '%.*ls' must include a data type.

177

15

The IDENTITY function can only be used when the SELECT statement has an INTO clause.

179

15

Cannot use the OUTPUT option when passing a constant to a stored procedure.

181

15

Cannot use the OUTPUT option in a DECLARE statement.

183

15

The scale (%d) for column '%.*ls' must be within the range %d to %d.

186

15

Data stream missing from WRITETEXT statement.

189

15

The %ls function requires %d to %d arguments.

191

15

Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

193

15

The object or column name starting with '%.*ls' is too long. The maximum length is %d characters.

195

15

'%.*ls' is not a recognized %S_MSG.

198

15

Browse mode is invalid for statements containing a UNION operator.

201

16

Procedure '%.*ls' expects parameter '%.*ls', which was not supplied.

204

20

Normalization error in node %ls.

206

16

Operand type clash: %ls is incompatible with %ls

208

16

Invalid object name '%.*ls'.

210

16

Syntax error converting datetime from binary/varbinary string.

213

16

Insert Error: Column name or number of supplied values does not match table definition.

217

16

Maximum stored procedure nesting level exceeded (limit %d).

221

10

FIPS Warning: Implicit conversion from %ls to %ls.

224

11

Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default.

229

14

%ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'.

231

11

No such default. ID = %ld, database ID = %d.

233

16

The column '%.*ls' in table '%.*ls' cannot be null.

235

16

Cannot convert a char value to money. The char value has incorrect syntax.

237

16

There is insufficient result space to convert a money value to %ls.

241

16

Syntax error converting datetime from character string.

243

16

Type %.*ls is not a defined system type.

245

16

Syntax error converting the %ls value '%.*ls' to a column of data type %ls.

251

16

Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.

256

16

The data type %ls is invalid for the %ls function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.

259

16

Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.

261

16

'%.*ls' is not a recognized function.

263

16

Must specify table to select from.

266

16

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count = %ld.

268

16

Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.

271

16

Column '%.*ls' cannot be modified because it is a computed column.

273

16

Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column.

279

16

The text, ntext, and image data types are invalid in this subquery or aggregate expression.

281

16

%d is not a valid style number when converting from datetime to a character string.

284

16

Rules cannot be bound to text, ntext, or image data types.

286

16

The logical tables INSERTED and DELETED cannot be updated.

288

16

The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.

293

16

Cannot convert char value to smallmoney. The char value has incorrect syntax.

295

16

Syntax error converting character string to smalldatetime data type.

298

16

The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.

301

16

Query contains an outer-join request that is not permitted.

306

16

The text, ntext, and image data types cannot be used in the WHERE, HAVING, or ON clause, except with the LIKE or IS NULL predicates.

308

16

Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist.

311

16

Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.

401

16

Unimplemented statement or expression %ls.

409

16

The %ls operation cannot take a %ls data type as an argument.

411

20

COMPUTE clause #%d, aggregate expression #%d is not in the select list.

425

16

Data type %ls of receiving variable is not equal to the data type %ls of column '%.*ls'.

427

20

Could not load sysprocedures entries for constraint ID %d in database ID %d.

429

20

Could not find new constraint ID %d in sysconstraints, database ID %d, at compile time.

431

19

Could not bind foreign key constraint. Too many tables involved in the query.

436

20

Could not open referenced table ID %d in database ID %d.

438

20

Could not resolve the referencing column name in table ID %d.

441

16

Cannot use the '%ls' function on a remote data source.

506

16

Invalid ESCAPE character '%.*hs' has been specified in a LIKE predicate.

509

11

User name '%.*ls' not found.

511

16

Cannot create a row of size %d which is greater than the allowable maximum of %d.

513

16

A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database '%.*ls', table '%.*ls', column '%.*ls'.

516

18

Could not get system date/time.

518

16

Cannot convert data type %ls to %ls.

529

16

Explicit conversion from data type %ls to %ls is not allowed.

535

16

Difference of two datetime columns caused overflow at runtime.

538

16

Cannot find '%.*ls'. This language may have been dropped. Contact your system administrator.

544

16

Cannot insert explicit value for identity column in table '%.*ls' when IDENTITY_INSERT is set to OFF.

547

16

%ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.

550

16

The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.

553

16

%hs over nullable side of outer join query on table '%ls'.

556

16

INSERT EXEC failed because the stored procedure altered the schema of the target table.

602

21

Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.

605

21

Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.

615

21

Could not find database table ID %d, name '%.*ls'.

618

21

A varno of %d was passed to the opentable system function. The largest valid value is %d.

624

21

Could not retrieve row from page by RID because the requested RID has a higher number than the last RID on the page. %S_RID.%S_PAGE, DBID %d.

626

16

Cannot use ROLLBACK with a savepoint within a distributed transaction.

628

13

Cannot issue SAVE TRANSACTION when there is no active transaction.

637

20

Index shrink program returned invalid status of 0.

644

21

Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.

650

16

You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

652

16

Index ID %d for table '%.*ls' resides on a read-only filegroup which cannot be modified.

654

20

No slots are free to keep buffers for table '%.*ls'.

666

16

Maximum system-generated unique value for a duplicate group exceeded for table ID %d, index ID %d. Dropping and re-creating the index may fix the problem; otherwise use another clustering key.

708

10

Warning: Due to low virtual memory, special reserved memory used %d times since startup. Increase virtual memory on server.

804

20

Could not find buffer 0x%lx holding logical page %S_PGID in the SDES 0x%lx kept buffer pool for object '%.*ls'.

813

20

Logical page %S_PGID in database ID %d is already hashed.

818

19

There is no room to hold the buffer resource lock %S_BUF in SDES %S_SDES. Contact Technical Support.

822

21

Could not start I/O for request %S_BLKIOPTR.

834

21

The bufclean system function was called on dirty buffer (page %S_PGID, stat %#x/%#x, objid %#x, sstat%#x).

844

10

Time out occurred while waiting for buffer latch type %d, bp %#x, page %S_PGID, stat %#x, object ID %d:%d:%d, waittime %d. Continuing to wait.

901

21

Could not find descriptor for database ID %d, object ID %ld in hash table after hashing it.

906

22

Could not locate row in sysobjects for system catalog '%.*ls' in database '%.*ls'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.

913

22

Could not find database ID %d. Database may not be activated yet or may be in transition.

921

14

Database '%.*ls' has not been recovered yet. Wait and try again.

923

14

User %d not allowed in database '%.*ls'. Only the owner can access this database.

925

19

Maximum number of databases used for each query has been exceeded. The maximum allowed is %d.

927

14

Database '%.*ls' cannot be opened. It is in the middle of a restore.

941

14

Cannot open database '%.*ls'. It has not been upgraded to the latest format.

943

14

Database '%.*ls' cannot be opened because its version (%d) is later than the current server version (%d).

945

16

Database '%.*ls' cannot be opened because some of the files could not be activated.

947

16

Error while closing database '%.*ls' cleanly.

1001 

16

Line %d: Length or precision specification %d is invalid.

1003 

15

Line %d: %ls clause allowed only for %ls.

1006 

15

CREATE TRIGGER contains no statements.

1008 

15

The SELECT item identified by the ORDER BY number %d contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.

1011 

15

The correlation name '%.*ls' is specified multiple times in a FROM clause.

1013 

15

Tables '%.*ls' and '%.*ls' have the same exposed names. Use correlation names to distinguish them.

1016 

15

Outer join operators cannot be specified in a query containing joined tables.

1020 

15

Cannot specify column list for INSERT/DELETE/EXECUTE privileges in the GRANT/REVOKE statement.

1022 

10

FIPS Warning: Line %d has the non-ANSI clause '%ls'.

1024 

10

FIPS Warning: Line %d has the non-ANSI function '%ls'.

1027 

15

Too many expressions are specified in the GROUP BY clause. The maximum number is %d when either CUBE or ROLLUP is specified.

1029 

15

Browse mode is invalid for subqueries and derived tables.

1032 

16

Cannot use the column prefix '%.*ls'. This must match the object in the UPDATE clause '%.*ls'.

1035 

15

Incorrect syntax near '%.*ls', expected '%.*ls'.

1037 

15

The CASCADE, WITH GRANT or AS options cannot be specified with statement permissions.

1039 

15

SHOWPLAN is not available. Use SHOWPLAN_TEXT or SHOWPLAN_ALL instead.

1041 

15

Option %.*ls is not allowed for a LOG file.

1043 

15

'%hs' is not yet implemented.

1045 

15

Aggregates are not allowed in this context. Only scalar expressions are allowed.

1047 

15

Conflicting locking hints specified.

1049 

15

Mixing old and new syntax to specify cursor options is not allowed.

1051 

15

Cursor parameters in a stored procedure must be declared with OUTPUT and VARYING options, and they must be specified in the order CURSOR VARYING OUTPUT.

1053 

15

For DROP STATISTICS, you must give both the table and the column name in the form 'tablename.column'.

1056 

15

The maximum number of elements in the select list is %d and you have supplied %d.

1058 

15

Cannot specify both READ_ONLY and FOR READ ONLY on a cursor declaration.

1060 

15

The number of rows in the TOP clause must be an integer.

1062 

16

The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.

1064 

16

A filegroup cannot be used with log files.

1066 

10

Warning. Line %d: The option '%ls' is obsolete and has no effect.

1068 

16

Only one list of index hints per table is allowed.

1070 

15

CREATE INDEX option '%.*ls' is no longer supported.

1072 

16

A REMOTE hint can only be specified with an INNER JOIN clause.

1101 

17

Could not allocate new page for database '%.*ls'. There are no more pages available in filegroup %.*ls. Space can be created by dropping objects, adding additional files, or allowing file growth.

1103 

21

Allocation page %S_PGID in database '%.*ls' has different segment ID than that of the object which is being allocated to. Run DBCC CHECKALLOC.

1109 

21

Could not read allocation page %S_PGID because either the object ID (%ld) is not correct, or the page ID (%S_PGID) is not correct.

1203

20

Process ID %d attempting to unlock unowned resource %.*ls.

1205

13

Your transaction (process ID #%d) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.

1220 

17

No more lock classes available from transaction.

1222 

13

Lock request time out period exceeded.

1505

14

CREATE UNIQUE INDEX terminated because a duplicate key was found. Most significant primary key is '%S_KEY'.

1508

14

CREATE INDEX terminated because a duplicate row was found. Primary key is '%S_KEY'.

1510

17

Sort failed. Out of space or locks in database '%.*ls'.

1522 

20

Sort failure. Prevented overwriting of allocation page in database '%.*ls' by terminating sort.

1528 

21

Character data comparison failure. An unrecognized Sort-Map-Element type (%d) was found in the server-wide default sort table at SMEL entry [%d].

1530

16

CREATE INDEX with DROP_EXISTING was aborted because a row was out of order. Most significant offending primary key is '%S_KEY'. Explicitly drop and create the index instead.

1532 

20

New sort run starting on page %S_PGID found extent not marked as shared.

1534 

20

Extent %S_PGID not found in shared extent directory.

1536 

20

Cannot build a nonclustered index on a memory-only work table.

1538 

20

Cannot insert into a sort not in row input phase.

1619 

21

Could not open tempdb. Cannot continue.

1702

16

CREATE TABLE failed because column '%.*ls' in table '%.*ls' exceeds the maximum of %d columns.

1704 

16

Only members of the sysadmin role can create the system table '%.*ls'.

1706 

16

System table '%.*ls' was not created, because ad hoc updates to system catalogs are not enabled.

1709 

16

Cannot use TEXTIMAGE_ON when a table has no text, ntext, or image columns.

1752 

16

Could not create DEFAULT for column '%.*ls' as it is not a valid column in the table '%.*ls'.

1754 

16

Defaults cannot be created on columns with an IDENTITY attribute. Table '%.*ls', column '%.*ls'.

1756 

10

Skipping FOREIGN KEY constraint '%.*ls' definition for temporary table.

1760 

16

Constraints of type %ls cannot be created on columns of type %ls.

1766 

16

Foreign key references to temporary tables are not supported. Foreign key '%.*ls'.

1768 

16

Foreign key '%.*ls' references object '%.*ls' which is not a user table.

1770 

16

Foreign key '%.*ls' references invalid column '%.*ls' in referenced table '%.*ls'.

1773 

16

Foreign key '%.*ls' has implicit reference to object '%.*ls' which does not have a primary key defined on it.

1776 

16

There are no primary or candidate keys in the referenced table '%.*ls' that match the referencing column list in the foreign key '%.*ls'.

1778 

16

Column '%.*ls.%.*ls' is not the same data type as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'.

1780 

20

Could not find column ID %d in syscolumns for object ID %d in database ID %d.

1801 

16

Database '%.*ls' already exists.

1803

17

CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks. Total space allocated must be at least %d MB to a accommodate copy of the model database.

1805 

10

The CREATE DATABASE process is allocating %.2f MB on disk '%.*ls'.

1808 

21

Default devices are not supported.

1813 

16

Could not open new database '%.*ls'. CREATE DATABASE is aborted.

1816 

16

Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server.

1818 

16

Primary log file '%ls' is missing and the database was not cleanly shut down so it cannot be rebuilt.

1820 

16

Disk '%.*ls' is already completely used by other databases. It can be expanded with DISK RESIZE.

1827 

16

CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of %d MB per %S_MSG.

1829 

16

The FOR ATTACH option requires that at least the primary file be specified.

1831 

10

Successfully %ls database '%.*ls'.

1901 

16

Column '%.*ls'. Cannot create index on a column of bit data type.

1903

16

%d is the maximum allowable size of an index. The composite index specified is %d bytes.

1905 

21

Could not find 'zero' row for index '%.*ls' the table in sysindexes.

1909 

16

Cannot use duplicate column names in index key list. Column name '%.*ls' listed more than once.

1914 

16

Cannot create index on object '%.*ls' because it is not a user table.

1916

16

CREATE INDEX options %ls and %ls are mutually exclusive.

1919 

16

Column '%.*ls'. Cannot create index on a column of text, ntext, or image data type.

1921 

16

Invalid filegroup '%.*ls' specified.

1923 

10

The clustered index has been dropped.

1925 

16

Cannot convert a clustered index to a nonclustered index using the DROP_EXISTING option.

1927 

16

There are already statistics on table '%.*ls' named '%.*ls'.

1929 

16

Cannot create statistics on table '%.*ls' because it is not a user table.

2001 

10

Cannot use duplicate parameter names. Parameter name '%.*ls' listed more than once.

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.

2009 

10

Procedure '%.*ls' was created despite delayed name resolution warnings (if any).

2106 

11

Cannot create a trigger on table '%.*ls', because this table does not exist in database '%.*ls'.

2109 

16

Cannot create a trigger on table '%.*ls' that accesses 'inserted' or 'deleted' because the table was created with the no_log option.

2501

16

Could not find table named '%.*ls'. Check sysobjects.

2503 

10

Successfully deleted the physical file '%ls'.

2505 

16

The device '%.*ls' does not exist. Use sp_helpdevice to show available devices.

2513

16

Table Corrupt: Object ID %ld (object '%.*ls') does not match between '%.*ls' and '%.*ls'.

2520 

16

Could not find database '%.*ls'. Check sysdatabases.

2526 

16

Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.

2532 

16

DBCC SHRINKFILE could not shrink file %ls. Log files are not supported.

2536 

10

DBCC results for '%.*ls'.

2539 

10

Total number of extents = %ld, used pages = %ld, referenced pages = %ld in this database.

2541 

10

DBCC UPDATEUSAGE: sysindexes row updated for table '%.*ls' (index ID %ld):

2543 

10

USED pages: Changed from (%ld) to (%ld) pages.

2545 

10

ROWS count: Changed from (%I64d) to (%I64d) rows.

2560 

16

Parameter %d is incorrect for this DBCC statement.

2566 

14

DBCC DBREINDEX cannot be used on system tables.

2571 

10

Only members of the sysadmin role can use the DBCC statement %.*ls.

2574 

10

Object ID %d, index ID %d: Page %S_PGID is empty. This is not permitted at level %d of the B-tree.

2588 

16

Page %S_PGID was expected to be the first page of a text, ntext, or image value.

2592 

10

%ls index successfully restored for object '%.*ls' in database '%.*ls'.

2594 

16

Invalid index ID (%d) specified.

2597 

16

The database is not open. Execute a 'USE %.*ls' statement and rerun the DBCC statement.

2601

14

Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.

2617 

20

Buffer holding logical page %S_PGID not found in keep pool in SDES for object '%.*ls'. Contact Technical Support.

2627 

14

Violation of %ls constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'.

2702 

16

Database '%.*ls' does not exist.

2706 

11

Table '%.*ls' does not exist.

2714 

16

There is already an object named '%.*ls' in the database.

2716 

16

Column or parameter #%d: Cannot specify a column width on data type %.*ls.

2718 

16

Column or parameter #%d: Cannot specify null values on a column of data type bit.

2724 

10

Parameter '%.*ls' has an invalid data type.

2729 

16

Procedure '%.*ls' group number 1 already exists in the database. Choose another procedure name.

2732 

16

User error number %ld is invalid. The number must be between %ld and %ld.

2736 

16

Owner name specified is a group name. Objects cannot be owned by groups.

2738 

16

A table can only have one timestamp column. Because table '%.*ls' already has one, the column '%.*ls' cannot be added.

2740 

16

SET LANGUAGE failed because '%.*ls' is not an official language name or a language alias on this SQL Server.

2742 

16

SET DATEFIRST %d is out of range.

2744 

16

Multiple identity columns specified for table '%.*ls'. Only one identity column per table is allowed.

2746 

16

Cannot specify user error format string with a length exceeding %d bytes.

2748 

16

Cannot specify %ls data type (RAISERROR parameter %d) as a substitution parameter for RAISERRROR.

2750

16

Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.

2752 

16

Identity column '%.*ls' contains invalid SEED.

2754 

16

Error severity levels greater than %d can only be specified by members of the sysadmin role, using the WITH LOG option.

2756 

16

Invalid value %d for state. Valid range is from %d to %d.

2758 

16

%hs could not locate entry for error %d in sysmessages.

2760 

16

Specified owner name '%.*ls' either does not exist or you do not have permission to use it.

2762 

16

sp_setapprole was not invoked correctly. Refer to the documentation for more information.

2764 

16

Incorrect password supplied for application role '%.*ls'.

2766 

16

The definition for user-defined data type '%.*ls' has changed.

2768 

15

Statistics for %ls '%.*ls'.

2770 

16

The SELECT INTO statement cannot have same source and destination tables.

2809 

18

The request for %S_MSG '%.*ls' failed because '%.*ls' is a %S_MSG object.

3009 

16

Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.

3014 

10

Backup or restore operation successfully processed %d pages in %d.%03d seconds (%d.%03d MB/sec).

3016 

16

File '%ls' of database '%ls' has been removed or shrunk since this backup or restore operation was interrupted. The operation cannot be restarted.

3018 

16

There is no interrupted backup or restore operation to restart. Reissue the statement without the RESTART clause.

3020 

16

The backup operation cannot be restarted as the log has been truncated. Reissue the statement without the RESTART clause.

3023

16

Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.

3025 

16

Missing database name. Reissue the statement specifying a valid database name.

3027 

16

Could not find filegroup '%.*ls' in sysfilegroups for database '%.*ls'.

3029 

16

Database file '%ls' is subject to logical recovery and must be among the files to be backed up as part of the file or filegroup backup.

3031 

16

The statement has inconsistent or conflicting options. Remove the conflicting option and reissue the statement.

3033 

16

BACKUP DATABASE cannot be used on a database opened in emergency mode.

3035 

16

Cannot perform a differential backup for database '%ls', because a current database backup does not exist. Reissue the statement omitting the WITH DIFFERENTIAL option.

3101

16

Database in use. The system administrator must have exclusive use of the database to run the restore operation.

3108 

16

RESTORE DATABASE must be used in single user mode when trying to restore the master database.

3112 

16

Cannot restore any database other than master when the server is in single user mode.

3114 

21

Database '%.*ls' does not have an entry in sysdatabases.

3116 

10

When all restore transactions have been completed for database '%.*ls', user '%.*ls' should be given the next available SUID.

3120

16

The database you are attempting to restore was backed up under a different sort order ID (%d) than the one currently running on this server (%d), and at least one of them is a non-binary sort order.

3127 

16

Temporary Message: The backup set does not contain pages for file '%ls'.

3129 

16

Temporary Message: File '%ls' has changed size from %d to %d bytes.

3133 

16

The volume on device '%ls' is not a member of the media family.

3136 

16

Cannot apply the differential backup on device '%ls' to database '%ls'.

3140 

16

Could not adjust the space allocation for file '%ls'.

3142 

16

One or more devices or files already exist. Reissue the statement using the WITH REPLACE option to overwrite these files and devices.

3144 

16

File '%.*ls' was not backed up in file %d on device '%ls'. The file cannot be restored from this backup set.

3146 

16

None of the newly-restored files had been modified after the backup was taken, so no further recovery actions are required. The database is now available for use.

3148 

16

Media recovery for ALTER DATABASE is not yet implemented. The database cannot be rolled forward.

3150 

10

The master database has been successfully restored. Shutting down SQL Server.

3152 

16

Cannot overwrite file '%ls' because it is marked as read-only.

3154

16

The backup set holds a backup of a database other than the existing '%ls' database.

3156 

16

The file '%ls' cannot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file.

3158 

16

Could not create one or more files. Consider using the WITH MOVE option to identify valid locations.

3160 

16

Could not update primary file information in sysdatabases.

3162 

16

The database has on-disk structure version %d. The server supports version %d and can only restore such a database that was inactive when it was backed up. This database was not inactive.

3164 

16

Cannot roll forward the database with on-disk structure version %d. The server supports version %d. Reissue the RESTORE statement WITH RECOVERY.

3166 

16

RESTORE DATABASE could not drop database '%ls'. Drop the database and then reissue the RESTORE DATABASE statement.

3201 

16

Cannot open backup device '%ls'. Device error or device off-line. See the SQL Server error log for more details.

3203 

16

Read on '%ls' failed, status = %ld. See the SQL Server error log for more details.

3205 

16

Too many backup devices specified for backup or restore; only %d are allowed.

3207 

16

Backup or restore requires at least one backup device. Rerun your statement specifying a backup device.

3209

16

'%.*ls' is not a backup device. Check sysdevices.

3217 

16

Invalid value specified for %ls parameter.

3222 

16

The WriteFileEx system function executed on file '%ls' only wrote %d bytes, expected %d.

3227

16

The volume on device '%ls' is a duplicate of stripe set member %d.

3230 

16

Operation on device '%ls' exceeded retry count.

3235 

16

File '%ls' is not part of database '%ls'. You can only list files that are members of this database.

3239 

16

The backup set on device '%ls' uses a feature of the Microsoft Tape Format not supported by SQL Server.

3242

16

The file on device '%ls' is not a valid Microsoft Tape Format backup set.

3244 

16

Descriptor block size exceeds %d bytes. Use a shorter name and/or description string and retry the operation.

3246 

16

The media family on device '%ls' is marked as nonappendable. Reissue the statement using the INIT option to overwrite the media.

3248 

25

>>> VOLUME SWITCH <<< (not for output!)

3250 

16

The value '%d' is not within range for the %ls parameter.

3252 

16

Passwords on media and/or data sets are not supported in this release of SQL Server.

3254 

16

The volume on device '%ls' is empty.

3256

16

The backup set on device '%ls' was terminated while it was being created and is incomplete. RESTORE sequence is terminated abnormally.

3258

16

The volume on device '%ls' belongs to a different media set.

3260 

16

An internal buffer has become full.

3262 

10

The backup set is valid.

3264 

16

The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.

3266 

10

The Microsoft Tape Format (MTF) soft filemark database on backup device '%ls' cannot be read, inhibiting random access.

3268 

16

Cannot use the backup file '%ls' because it was originally formatted with sector size %d and is now on a device with sector size %d.

3270 

16

An internal consistency error occurred. Contact Technical Support for assistance.

3272 

16

The '%ls' device has a hardware sector size of %d, but the block size parameter specifies an incompatible override value of %d. Reissue the statement using a compatible block size.

3307 

21

Process %d was expected to hold logical lock on page %S_PGID.

3314 

21

Error while undoing logged operation in database '%.*ls'. Error at log record ID %S_LSN.

3406 

10

%d transactions rolled forward in database '%.*ls' (%d).

3408 

10

Recovery complete.

3414

10

Database '%.*ls' (database ID %d) could not recover. Contact Technical Support.

3417 

21

Cannot recover the master database. Exiting.

3430 

10

Warning: Could not determine the outcome of transaction %S_XID, named '%.*ls' in database '%.*ls' (with ID %d) because the coordinating database (ID %d) did not contain the outcome. The transaction was assumed to be committed.

3432 

16

Warning: syslanguages is missing.

3434 

20

Cannot change sort order or locale. Server shutting down. Restart SQL Server to continue with sort order unchanged.

3436 

20

Cannot rebuild index ID %d for the '%.*ls' table in the '%.*ls' database.

3438 

10

Database '%.*ls' (database ID %d) failed to recover because transaction first LSN is not equal to LSN in checkpoint. Contact Technical Support.

3440 

21

Database '%.*ls' (database ID %d). The DBCC RECOVERDB statement can only be run after a RESTORE statement that used the WITH NORECOVERY option.

3442 

21

Database '%.*ls' (database ID %d). The size of the undo file is insufficient.

3444 

21

Database '%.*ls' (database ID %d). Could not find start of previous recovery operation. The RESTORE LOG statement cannot be performed.

3446 

16

Primary file not available for database '%.*ls'.

3448 

21

Could not undo log record %S_LSN, for transaction ID %S_XID, on page %S_PGID, database '%.*ls' (database ID %d). Page information: LSN = %S_LSN, type = %ld. Log information: OpCode = %ld, context %ld.

3450 

10

Recovery progress on database '%.*ls' (%d): %d percent.

3452 

10

Recovery of database '%.*ls' (%d) detected possible identity value inconsistency in table ID %d. Run DBCC CHECKIDENT ('%.*ls').

3501 

21

Could not find row in sysdatabases for database ID %d at checkpoint time.

3508 

25

Could not get an exclusive lock on the database '%.*ls'. Make sure that no other users are currently using this database, and rerun the CHECKPOINT statement.

3510 

16

Database '%.*ls' cannot be changed from read-only because the primary and/or log file(s) are not writable.

3605 

10

Duplicate row was ignored.

3607 

10

Division by zero occurred.

3612 

10

%hsSQL Server Execution Times:%hs CPU time = %lu ms, elapsed time = %lu ms.

3615 

10

Table '%.*ls'. Scan count %d, logical reads %d, physical reads %d, read-ahead reads %d.

3619 

10

Could not write a CHECKPOINT record in database ID %d because the log is out of space.

3621 

10

The statement has been terminated.

3623 

10

A transaction on a no_log table was undone. See the SQL Server errorlog for details.

3627

16

Could not create worker thread.

3702 

16

Cannot drop the %S_MSG '%.*ls' because it is currently in use.

3705 

16

Cannot use DROP %ls with '%.*ls' because '%.*ls' is a %S_MSG. Use DROP %ls.

3716 

16

The %S_MSG '%.*ls' cannot be dropped because it is bound to one or more %S_MSG.

3723 

16

An explicit DROP INDEX is not allowed on index '%.*ls'. It is being used for %ls constraint enforcement.

3725 

16

The constraint '%.*ls' is being referenced by table '%.*ls', foreign key constraint '%.*ls'.

3727 

10

Could not drop constraint. See previous errors.

3733 

16

Constraint '%.*ls' does not belong to table '%.*ls'.

3740 

16

Cannot drop the %S_MSG '%.*ls' because at least part of the table resides on a read-only filegroup.

3903 

13

The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

3906 

16

Could not run BEGIN TRANSACTION in database '%.*ls' because the database is read-only.

3909 

16

Session binding token is invalid or corrupt.

3912 

16

Cannot bind using an XP token while the server is not in an XP call.

3915 

16

Cannot use the ROLLBACK statement within an INSERT-EXEC statement.

3917 

16

Session is bound to a transaction context that is in use. Other statements in the batch were ignored.

4003 

21

ODS error. Server is terminating this connection.

4015 

16

Language requested in login '%.*ls' is not an official name on this SQL Server. Using server-wide default %.*ls instead.

4017 

16

Neither the language requested in 'login %.*ls' nor user default language %.*ls is an official language name on this SQL Server. Using server-wide default %.*ls instead.

4019 

16

Language requested in login '%.*ls' is not an official language name on this SQL Server. Login fails.

4027 

16

Mount tape for %hs of database '%ls'.

4030 

10

The medium on device '%ls' expires on %hs and cannot be overwritten.

4037 

16

User-specified volume ID '%ls' does not match the volume ID '%ls' of the device '%ls'.

4060 

11

Cannot open database requested in login '%.*ls'. Login fails.

4062 

11

Cannot open user default database '%.*ls'. Using master database instead.

4207

16

BACKUP LOG is not allowed while the select into/bulkcopy option is enabled. Use BACKUP DATABASE or disable the option using sp_dboption.

4212 

16

Cannot back up the log of the master database. Use BACKUP DATABASE instead.

4214

10

There is no current database backup. This log backup cannot be used to roll forward a preceding database backup.

4301 

16

Database in use. The system administrator must have exclusive use of the database to restore the log.

4305

16

This backup set cannot be restored because the database has not been rolled forward far enough. You must first restore all earlier logs before restoring this log.

4312 

16

Only members of the sysadmin role or owner of database '%.*ls' can run RESTORE LOG.

4318

16

File '%ls' has been rolled forward to LSN %.*ls. This log terminates at LSN %.*ls, which is too early to apply the WITH RECOVERY option. Reissue the RESTORE LOG statement WITH NORECOVERY.

4320 

16

File '%ls' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.

4322 

10

This log file contains records logged before the designated point-in-time. The database is being left in load state so you can apply another log file.

4324 

10

Backup history older than %ls has been deleted.

4403 

16

View '%.*ls' is not updatable because it contains aggregates.

4405 

16

View '%.*ls' is not updatable because the FROM clause names multiple tables.

4408 

19

The query and the views in it exceed the limit of %d tables.

4414 

16

Could not allocate ancillary table for view resolution. The maximum number of tables in a query (%d) was exceeded.

4416 

16

View '%.*ls' is not updatable because the definition contains a UNION operator.

4418 

16

Derived table '%.*ls' is not updatable because it contains aggregates.

4420 

16

Derived table '%.*ls' is not updatable because the FROM clause names multiple tables.

4424 

16

Joined tables cannot be specified in a query containing outer join operators. View '%.*ls' contains joined tables.

4427 

16

The view '%.*ls' is not updatable because the definition contains the TOP clause.

4429 

16

View '%.*ls' contains a self-reference. Views cannot reference themselves directly or indirectly.

4501 

16

View '%.*ls' has more columns defined than column names given.

4504 

16

Could not perform CREATE TABLE because there was not enough space to allocate memory for the table.

4506 

10

Column names in each view must be unique. Column name '%.*ls' in view '%.*ls' is specified more than once.

4510 

16

Could not perform CREATE VIEW because WITH CHECK OPTION was specified and the view is not updatable.

4602 

14

Only members of the sysadmin role can grant or revoke the CREATE DATABASE permission.

4604 

16

There is no such user or group '%.*ls'.

4610 

16

You can only grant or revoke permissions on objects in the current database.

4613 

16

Grantor does not have GRANT permission.

4617 

16

Cannot grant, deny or revoke permissions to or from special roles.

4619 

16

CREATE DATABASE permission can only be granted in the master database.

4706 

17

Could not truncate table '%.*ls' because there is not enough room in the log to record the deallocation of all the index and data pages.

4708 

16

Could not truncate object '%.*ls' because it is not a table.

4710 

16

Only the owner or members of the sysadmin role can truncate table '%.*ls'.

4712 

16

Cannot truncate table '%.*ls' because it is being referenced by a FOREIGN KEY constraint.

4803 

21

Received invalid row length %d from bcp client. Maximum row size is %d.

4805 

17

The front-end tool you are using does not support the feature of bulk insert from host. Use the proper tools for this command.

4810 

16

Expected the TEXT token in data stream for bulk copy of text or image data.

4812 

16

Expected the row offset in data stream for bulk copy of text or image data.

4815 

21

Received invalid column length from bcp client.

4818 

16

Could not bulk insert. Sorted column '%.*ls' was specified more than once. Assuming data stream is not sorted.

4820 

16

Could not bulk insert. Unknown version of format file '%s'.

4822 

16

Could not bulk insert. Invalid number of columns in format file '%s'.

4824 

16

Could not bulk insert. Invalid data type for column number %d in format file '%s'.

4826 

16

Could not bulk insert. Invalid column length for column number %d in format file '%s'.

4828 

16

Could not bulk insert. Invalid destination table column number for source column %d in format file '%s'.

4830 

10

Bulk Insert: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.

4832 

16

Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.

4834 

16

Permission denied. Only members of the sysadmin role can use the BULK INSERT statement.

4836 

10

Warning: Table '%s' is published for merge replication. Reinitialize affected subscribers or execute sp_addtabletocontents to ensure that data added is included in the next sychronization.

4849 

16

Could not import table '%ls'. Error %d.

4851 

10

Data import: Table '%ls' already has data. Skipping to next table.

4853 

10

%hs

4860 

16

Could not bulk insert. File '%ls' does not exist.

4862 

16

Could not bulk insert because file '%ls' could not be read. Operating system error code %ls.

4864 

16

Bulk insert data conversion error (type mismatch) for row %d, column %d (%ls).

4866 

16

Could not bulk insert because column too long in data file. Make sure FieldTerminator and RowTerminator were specified correctly.

4901 

16

ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column '%.*ls' cannot be added to table '%.*ls' because it does not allow nulls and does not specify a DEFAULT definition.

4910 

16

Only the owner or members of the sysadmin role can alter table '%.*ls'.

4917 

16

Constraint '%.*ls' does not exist.

4921 

16

ALTER TABLE failed because trigger '%.*ls' does not belong to table '%.*ls'.

4923 

16

ALTER TABLE DROP COLUMN failed because '%.*ls' is the only data column in table '%.*ls'. A table must have at least one data column.

4925 

16

ALTER TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table '%.*ls' with ROWGUIDCOL property.

4927 

16

Cannot alter column '%.*ls' to be data type %.*ls.

4929 

16

Cannot alter the %S_MSG '%.*ls' because it is being published for replication.

4931 

16

Cannot add columns to %S_MSG '%.*ls' because it is being published for merge replication.

5001 

16

User must be in the master database.

5004 

16

Database must be in state where it can be checkpointed to use ALTER DATABASE.

5006 

16

Could not get exclusive use of %S_MSG '%.*ls' to perform the requested operation.

5009 

16

ALTER DATABASE failed. Some disk names listed in the statement were not found. Check that the names exist and are spelled correctly before rerunning the statement.

5013

16

The master and model databases cannot have files added to them. ALTER DATABASE was aborted.

5015 

16

ALTER DATABASE failed. The total size specified must be 1 MB or greater.

5018 

0

File '%.*ls' modified in sysaltfiles. Delete old file after restarting SQL Server.

5020 

16

The primary data or log file cannot be removed from a database.

5022 

16

Log file '%ls' for this database is already active.

5024 

16

No entry found for the primary log file in sysfiles1. Could not rebuild the log.

5026 

16

Could not create a new log file with file '%.*ls'. See previous errors.

5028 

16

The system could not activate enough of the database to rebuild the log.

5030 

16

The database could not be exclusively locked to perform the operation.

5035 

16

Filegroup '%.*ls' already exists in this database.

5037 

16

MODIFY FILE failed. Do not specify physical name.

5039 

16

MODIFY FILE failed. Specified size is less than current size.

5041 

16

MODIFY FILE failed. File '%.*ls' does not exist.

5043 

16

The %S_MSG '%.*ls' cannot be found in %ls.

5045 

16

The %S_MSG already has the '%ls' property set.

5047 

16

Cannot change the READONLY property of the PRIMARY filegroup.

5049 

16

Cannot extend file '%ls' using this syntax as it was not created with DISK INIT. Use ALTER DATABASE MODIFY FILE.

5051 

16

Cannot have a filegroup with the name 'DEFAULT'.

5054 

16

Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle.

5101 

15

You must supply parameters for the DISK %hs statement. Usage: %hs.

5103 

16

MAXSIZE cannot be less than SIZE for file '%ls'.

5105 

16

Device activation error. The physical file name '%.*ls' may be incorrect.

5107 

15

Value is wrong data type for parameter '%hs' (requires data type '%hs').

5116 

14

Permission denied. Only members of the sysadmin role can run DISK statements.

5122 

10

Each disk file size must be greater than or equal to 1 MB.

5126 

16

The logical device '%.*ls' does not exist in sysdevices.

5148 

16

Could not set the file size to the desired amount. The operating system file size limit may have been reached.

5150 

16

The size of a single log file must not be greater than 2 TB.

5154 

16

Device '%.*ls' is not open.

5157 

16

I/O error encountered in the writelog system function during backout.

5159 

16

Operating system error %.*ls on device '%.*ls' during %ls.

5162 

16

Cannot find '%.*ls' in sysdatabases.

5164 

16

Usage: DBCC DBCONTROL(dbname,ONLINE|OFFLINE)

5167 

16

Database '%.*ls' is already offline.

5169 

16

FILEGROWTH cannot be greater than MAXSIZE for file '%.*ls'.

5171 

16

%.*ls is not a primary database file.

5173 

16

Cannot associate files with different databases.

5175 

10

The file '%.*ls' has been expanded to prevent recovery from failing. Contact the system administrator for further assistance.

5177 

16

Encountered an unexpected error while checking the sector size for file '%.*ls'. Check the SQL Server error log for more information.

5179 

16

Cannot use file '%.*ls', which is on a device with sector size %d. SQL Server supports a maximum sector size of 4096 bytes.

5181 

16

Could not restart database '%.*ls'. Reverting back to old status.