Errors 4000 - 4999

Error Severity Description
4003 21 ODS error. Server is terminating this connection.
4004 16 ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.
4015 16 Language requested in login '%.*ls' is not an official name on this SQL Server. Using server-wide default %.*ls instead.
4016 16 Language requested in 'login %.*ls' is not an official name on this SQL Server. Using user 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.
4018 16 User default language %.*ls is not 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.
4020 16 Default date order '%.*ls' for language %.*ls is invalid. Using mdy instead.
4027 16 Mount tape for %hs of database '%ls'.
4028 16 End of tape has been reached. Remove tape '%ls' and mount next tape for %hs of database '%ls'.
4030 10 The medium on device '%ls' expires on %hs and cannot be overwritten.
4035 10 Processed %d pages for database '%ls', file '%ls' on file %d.
4037 16 User-specified volume ID '%ls' does not match the volume ID '%ls' of the device '%ls'.
4038 16 Cannot find file ID %d on device '%ls'.
4060 11 Cannot open database requested in login '%.*ls'. Login fails.
4061 11 Cannot open either database requested in login (%.*ls) or user default database (%.*ls). Using master database instead.
4062 11 Cannot open user default database '%.*ls'. Using master database instead.
4063 11 Cannot open database requested in login (%.*ls). Using user default '%.*ls' 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.
4208 16 BACKUP LOG is not allowed while the trunc. log on chkpt. 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.
4213 16 Cannot allow BACKUP LOG because file '%ls' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup.
4214 10 There is no current database backup. This log backup cannot be used to roll forward a preceding database backup.
4215 10 The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed.
4301 16 Database in use. The system administrator must have exclusive use of the database to restore the log.
4304 16 A USER ATTENTION signal raised during RESTORE LOG is being ignored until the current restore completes.
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.
4306 16 The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
4312 16 Only members of the sysadmin role or owner of database '%.*ls' can run RESTORE LOG.
4316 16 Can only RESTORE LOG in the master database if SQL Server is in single user mode.
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.
4319 16 Cannot use the STOPAT and NORECOVERY options together. Reissue the statement specifying WITH RECOVERY to roll the database forward to a specific point in time.
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.
4321 16 The minimum recovery point of the database is beyond the specified point-in-time. Reissue this statement without specifying STOPAT.
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.
4323 16 The database is marked suspect. Transaction logs cannot be restored. Use RESTORE DATABASE to recover the database.
4324 10 Backup history older than %ls has been deleted.
4325 16 Could not delete entries for backup set ID '%ls'.
4403 16 View '%.*ls' is not updatable because it contains aggregates.
4404 16 View '%.*ls' is not updatable because the definition contains the DISTINCT clause.
4405 16 View '%.*ls' is not updatable because the FROM clause names multiple tables.
4406 16 View '%.*ls' is not updatable because a column of the view is derived or constant.
4408 19 The query and the views in it exceed the limit of %d tables.
4413 16 Could not use view '%.*ls' because of previous binding errors.
4414 16 Could not allocate ancillary table for view resolution. The maximum number of tables in a query (%d) was exceeded.
4415 16 View '%.*ls' is not updatable because either it was created WITH CHECK OPTION or it spans a view created WITH CHECK OPTION and the target table is referenced multiple times in the resulting query.
4416 16 View '%.*ls' is not updatable because the definition contains a UNION operator.
4417 16 Derived table '%.*ls' is not updatable because the definition contains a UNION operator.
4418 16 Derived table '%.*ls' is not updatable because it contains aggregates.
4419 16 Derived table '%.*ls' is not updatable because the definition contains the DISTINCT clause.
4420 16 Derived table '%.*ls' is not updatable because the FROM clause names multiple tables.
4421 16 Derived table '%.*ls' is not updatable because a column of the derived table is derived or constant.
4424 16 Joined tables cannot be specified in a query containing outer join operators. View '%.*ls' contains joined tables.
4425 16 Cannot specify outer join operators in a query containing joined tables. View '%.*ls' contains outer join operators.
4427 16 The view '%.*ls' is not updatable because the definition contains the TOP clause.
4428 16 The derived table '%.*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.
4430 10 Warning: Index hints supplied for view '%.*ls' will be ignored.
4501 16 View '%.*ls' has more columns defined than column names given.
4502 16 View '%.*ls' has more column names specified than columns defined.
4504 16 Could not perform CREATE TABLE because there was not enough space to allocate memory for the table.
4505 16 CREATE VIEW failed because column '%.*ls' in view '%.*ls' exceeds the maximum of %d columns.
4506 10 Column names in each view must be unique. Column name '%.*ls' in view '%.*ls' is specified more than once.
4508 16 Views are not allowed on temporary tables. Table names that begin with '#' denote temporary tables.
4510 16 Could not perform CREATE VIEW because WITH CHECK OPTION was specified and the view is not updatable.
4511 16 Could not perform CREATE VIEW because no column name was specified for column %d.
4602 14 Only members of the sysadmin role can grant or revoke the CREATE DATABASE permission.
4603 14 Only the owner of the current database can grant or revoke this permission.
4604 16 There is no such user or group '%.*ls'.
4606 16 Granted or revoked privilege %ls is not compatible with object.
4610 16 You can only grant or revoke permissions on objects in the current database.
4611 16 To revoke grantable privileges, specify the CASCADE option with REVOKE.
4613 16 Grantor does not have GRANT permission.
4615 16 Invalid column name '%.*ls'.
4617 16 Cannot grant, deny or revoke permissions to or from special roles.
4618 16 You do not have permission to use %.*ls in the AS clause.
4619 16 CREATE DATABASE permission can only be granted in the master database.
4701 11 Could not truncate table '%.*ls' because this table does not exist in database '%.*ls'.
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.
4707 16 Could not truncate object '%.*ls' because it or one of its indexes resides on a READONLY filegroup.
4708 16 Could not truncate object '%.*ls' because it is not a table.
4709 16 You are not allowed to truncate the system table '%.*ls'.
4710 16 Only the owner or members of the sysadmin role can truncate table '%.*ls'.
4711 16 Cannot truncate table '%.*ls' because it is published for replication.
4712 16 Cannot truncate table '%.*ls' because it is being referenced by a FOREIGN KEY constraint.
4801 20 Bulk_main: The opentable system function on BULK INSERT table failed. Database ID %d, name '%.*ls'.
4803 21 Received invalid row length %d from bcp client. Maximum row size is %d.
4804 21 Premature end-of-message while reading current row from host. Host program may have terminated.
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.
4807 21 Received invalid row length %d from bcp client. Minimum row size is %d.
4810 16 Expected the TEXT token in data stream for bulk copy of text or image data.
4811 16 Expected the column offset 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.
4813 16 Expected the text length in data stream for bulk copy of text, ntext, or image data.
4815 21 Received invalid column length from bcp client.
4817 16 Could not bulk insert. Invalid sorted column '%.*ls'. Assuming data stream is not sorted.
4818 16 Could not bulk insert. Sorted column '%.*ls' was specified more than once. Assuming data stream is not sorted.
4819 16 Could not bulk insert. Bulk data stream was incorrectly specified as sorted.
4820 16 Could not bulk insert. Unknown version of format file '%s'.
4821 16 Could not bulk insert. Error reading the number of columns from format file '%s'.
4822 16 Could not bulk insert. Invalid number of columns in format file '%s'.
4823 16 Could not bulk insert. Invalid column number in format file '%s'.
4824 16 Could not bulk insert. Invalid data type for column number %d in format file '%s'.
4825 16 Could not bulk insert. Invalid prefix 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'.
4827 16 Could not bulk insert. Invalid column terminator 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'.
4829 16 Could not bulk insert. Error reading destination table column name 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.
4831 10 Bulk Insert: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.
4832 16 Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.
4833 16 Bulk Insert: Version mismatch between the provider dynamic link library and the server executable.
4834 16 Permission denied. Only members of the sysadmin role can use the BULK INSERT statement.
4835 16 Bulk copying into a table with computed columns is not supported for downlevel clients.
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.
4837 16 Error: Cannot bulk copy into a table '%s' enabled for immediate-updating subscriptions
4849 16 Could not import table '%ls'. Error %d.
4850 10 Data import: Table '%ls' is already locked by another user.
4851 10 Data import: Table '%ls' already has data. Skipping to next table.
4852 10 Data import: Table '%ls' does not exist or it is not a user table.
4853 10 %hs
4854 21 %hs
4860 16 Could not bulk insert. File '%ls' does not exist.
4861 16 Could not bulk insert because file '%ls' could not be opened. Operating system error code %ls.
4862 16 Could not bulk insert because file '%ls' could not be read. Operating system error code %ls.
4863 16 Bulk insert data conversion error (truncation) for row %d, column %d (%ls).
4864 16 Bulk insert data conversion error (type mismatch) for row %d, column %d (%ls).
4865 16 Could not bulk insert because the maximum number of errors (%d) was exceeded.
4866 16 Could not bulk insert because column too long in data file. Make sure FieldTerminator and RowTerminator were specified correctly.
4867 16 Bulk insert data conversion error (overflow) for row %d, column %d (%ls).
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.
4902 11 Cannot alter table '%.*ls' because this table does not exist in database '%.*ls'.
4909 16 Cannot alter '%.*ls' because it is not a table.
4910 16 Only the owner or members of the sysadmin role can alter table '%.*ls'.
4916 16 Could not enable or disable the constraint. See previous errors.
4917 16 Constraint '%.*ls' does not exist.
4920 16 ALTER TABLE failed because trigger '%.*ls' on table '%.*ls' does not exist.
4921 16 ALTER TABLE failed because trigger '%.*ls' does not belong to table '%.*ls'.
4922 16 %ls %.*ls failed because %ls %.*ls accesses this column.
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.
4924 16 %ls failed because column '%.*ls' does not exist in table '%.*ls'.
4925 16 ALTER TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table '%.*ls' with ROWGUIDCOL property.
4926 16 ALTER TABLE ALTER COLUMN DROP ROWGUIDCOL failed because a column does not exist in table '%.*ls' with ROWGUIDCOL property.
4927 16 Cannot alter column '%.*ls' to be data type %.*ls.
4928 16 Cannot alter column '%.*ls' because it is '%ls'.
4929 16 Cannot alter the %S_MSG '%.*ls' because it is being published for replication.
4930 10 Warning: Columns added to the replicated table %S_MSG '%.*ls' will be ignored by existing articles.
4931 16 Cannot add columns to %S_MSG '%.*ls' because it is being published for merge replication.

  


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