| Error | Severity | Description |
|---|---|---|
| 5001 | 16 | User must be in the master database. |
| 5002 | 16 | Database '%.*ls' does not exist. Check sysdatabases. |
| 5004 | 16 | Database must be in state where it can be checkpointed to use ALTER DATABASE. |
| 5005 | 10 | Extending database by %.2f MB on disk '%.*ls'. |
| 5006 | 16 | Could not get exclusive use of %S_MSG '%.*ls' to perform the requested operation. |
| 5008 | 16 | ALTER DATABASE option not implemented yet. |
| 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. |
| 5011 | 14 | Only members of the sysadmin role or owner of database '%.*ls' can alter it. |
| 5013 | 16 | The master and model databases cannot have files added to them. ALTER DATABASE was aborted. |
| 5014 | 16 | The %S_MSG '%.*ls' does not exist in database '%.*ls'. |
| 5015 | 16 | ALTER DATABASE failed. The total size specified must be 1 MB or greater. |
| 5017 | 16 | ALTER DATABASE failed. Database '%.*ls' was not created with 'FOR LOAD' option. |
| 5018 | 0 | File '%.*ls' modified in sysaltfiles. Delete old file after restarting SQL Server. |
| 5019 | 16 | Could not find entry in sysaltfiles for file '%.*ls'. |
| 5020 | 16 | The primary data or log file cannot be removed from a database. |
| 5021 | 16 | MAXSIZE cannot be larger than the maximum database size of %ld MB. |
| 5022 | 16 | Log file '%ls' for this database is already active. |
| 5023 | 16 | Database must be put in bypass recovery mode to rebuild the log. |
| 5024 | 16 | No entry found for the primary log file in sysfiles1. Could not rebuild the log. |
| 5025 | 16 | The file '%ls' already exists. It should be renamed or deleted so that a new log file can be created. |
| 5026 | 16 | Could not create a new log file with file '%.*ls'. See previous errors. |
| 5027 | 16 | System databases master, model, and tempdb cannot have their logs rebuilt. |
| 5028 | 16 | The system could not activate enough of the database to rebuild the log. |
| 5029 | 10 | Warning: The log for database '%.*ls' has been rebuilt. Transactional consistency has been lost. DBCC CHECKDB should be run to validate physical consistency. Database options will have to be reset, and extra log files may need to be deleted. |
| 5030 | 16 | The database could not be exclusively locked to perform the operation. |
| 5031 | 16 | Cannot remove the file '%.*ls' because it is the only file in the DEFAULT filegroup. |
| 5035 | 16 | Filegroup '%.*ls' already exists in this database. |
| 5036 | 16 | MODIFY FILE failed. Specify logical name. |
| 5037 | 16 | MODIFY FILE failed. Do not specify physical name. |
| 5038 | 16 | MODIFY FILE failed. Only modify one file and one property at a time. |
| 5039 | 16 | MODIFY FILE failed. Specified size is less than current size. |
| 5040 | 16 | MODIFY FILE failed. Size is greater than MAXSIZE. |
| 5041 | 16 | MODIFY FILE failed. File '%.*ls' does not exist. |
| 5042 | 16 | The %S_MSG '%.*ls' cannot be removed because it is not empty. |
| 5043 | 16 | The %S_MSG '%.*ls' cannot be found in %ls. |
| 5044 | 10 | The %S_MSG '%.*ls' has been removed. |
| 5045 | 16 | The %S_MSG already has the '%ls' property set. |
| 5046 | 10 | The %S_MSG property '%ls' has been set. |
| 5047 | 16 | Cannot change the READONLY property of the PRIMARY filegroup. |
| 5048 | 16 | Cannot %ls file in read-only filegroup '%.*ls'. |
| 5049 | 16 | Cannot extend file '%ls' using this syntax as it was not created with DISK INIT. Use ALTER DATABASE MODIFY FILE. |
| 5050 | 16 | Cannot change the properties of empty filegroup '%.*ls'. The filegroup must contain at least one file. |
| 5051 | 16 | Cannot have a filegroup with the name 'DEFAULT'. |
| 5053 | 16 | The maximum of %ld filegroups per database has been exceeded. |
| 5054 | 16 | Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle. |
| 5055 | 16 | Cannot %ls read-only file '%.*ls'. |
| 5101 | 15 | You must supply parameters for the DISK %hs statement. Usage: %hs. |
| 5102 | 15 | No such statement DISK %.*ls. |
| 5103 | 16 | MAXSIZE cannot be less than SIZE for file '%ls'. |
| 5104 | 16 | File '%.*ls' already used. |
| 5105 | 16 | Device activation error. The physical file name '%.*ls' may be incorrect. |
| 5106 | 15 | Parameter '%hs' requires value of data type '%hs'. |
| 5107 | 15 | Value is wrong data type for parameter '%hs' (requires data type '%hs'). |
| 5109 | 16 | No such parameter '%.*ls'. |
| 5116 | 14 | Permission denied. Only members of the sysadmin role can run DISK statements. |
| 5117 | 16 | Could not run DISK statement. You must be in the master database to run this statement. |
| 5122 | 10 | Each disk file size must be greater than or equal to 1 MB. |
| 5123 | 16 | CREATE FILE encountered operating system error %ls while attempting to open or create the physical file '%.*ls'. |
| 5126 | 16 | The logical device '%.*ls' does not exist in sysdevices. |
| 5146 | 16 | The %hs of %d is out of range. It must be between %d and %d. |
| 5148 | 16 | Could not set the file size to the desired amount. The operating system file size limit may have been reached. |
| 5149 | 16 | MODIFY FILE encountered operating system error %ls while attempting to expand the physical file. |
| 5150 | 16 | The size of a single log file must not be greater than 2 TB. |
| 5151 | 16 | The %hs statement is obsolete and no longer supported. |
| 5154 | 16 | Device '%.*ls' is not open. |
| 5156 | 16 | Usage: DBCC DEVCONTROL(devname,ONLINE|OFFLINE) |
| 5157 | 16 | I/O error encountered in the writelog system function during backout. |
| 5158 | 10 | Warning: Media in device '%.*ls' may have been changed. |
| 5159 | 16 | Operating system error %.*ls on device '%.*ls' during %ls. |
| 5160 | 16 | Cannot take '%.*ls' offline because the database is in use. |
| 5162 | 16 | Cannot find '%.*ls' in sysdatabases. |
| 5163 | 16 | Cannot open '%.*ls' to take offline. |
| 5164 | 16 | Usage: DBCC DBCONTROL(dbname,ONLINE|OFFLINE) |
| 5165 | 16 | Cannot explicitly open or close master database. |
| 5167 | 16 | Database '%.*ls' is already offline. |
| 5168 | 16 | File '%.*ls' is on a network drive, which is not allowed. |
| 5169 | 16 | FILEGROWTH cannot be greater than MAXSIZE for file '%.*ls'. |
| 5170 | 16 | Cannot create file '%ls' because it already exists. |
| 5171 | 16 | %.*ls is not a primary database file. |
| 5172 | 16 | The header for file '%ls' is not a valid database file header. The %ls property is incorrect. |
| 5173 | 16 | Cannot associate files with different databases. |
| 5174 | 10 | Each file size must be greater than or equal to 512 KB. |
| 5175 | 10 | The file '%.*ls' has been expanded to prevent recovery from failing. Contact the system administrator for further assistance. |
| 5176 | 10 | The file '%.*ls' has been expanded beyond its maximum size 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. |
| 5178 | 16 | Cannot use file '%.*ls' because it was originally formatted with sector size %d and is now on a device with sector size %d. |
| 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. |
| 5180 | 22 | Could not open FCB for invalid file ID %d in database '%.*ls'. Table or database may be corrupted. |
| 5181 | 16 | Could not restart database '%.*ls'. Reverting back to old status. |
| 5701 | 10 | Changed database context to '%.*ls'. |
| 5702 | 10 | SQL Server is terminating this process. |
| 5703 | 10 | Changed language setting to %.*ls. |
| 5803 | 10 | Unknown config number (%d) in sysconfigures. |
| 5805 | 16 | Too few locks specified. Minimum %d. |
| 5807 | 16 | Recovery intervals above %d minutes not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration. |
| 5808 | 16 | Ad hoc updates to system catalogs not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration. |
| 5809 | 16 | Average time slices above %d milliseconds not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration. |
| 5810 | 16 | Valid values for the fill factor are 0 to 100. |
| 5812 | 14 | Permission denied. Only members of the sysadmin role can run RECONFIGURE. |
| 5823 | 16 | Cannot reconfigure SQL Server to use sort order ID %d, because the row for that sort order does not exist in syscharsets. |
| 5824 | 16 | Cannot reconfigure SQL Server to use sort order ID %d, because the row for its underlying character set (ID %d) does not exist in syscharsets. |
| 5825 | 16 | Cannot reconfigure the server's sort order because the syscharsets table does not exist. You must upgrade your server prior to attempting this. |
| 5826 | 10 | You have just reconfigured SQL Server's sort order. Table indexes on columns of type char or varchar will be rebuilt when SQL Server is restarted. |
| 5827 | 10 | By changing the default sort order, you have also reconfigured SQL Server's default character set. |
| 5828 | 16 | User connections are limited to %d. |
| 5829 | 16 | The specified user options value is invalid. |
| 5830 | 10 | You have just reconfigured SQL Server's Unicode collation. Table indexes on columns of type nchar or nvarchar will be rebuilt when SQL Server is restarted. |
| 5831 | 16 | Minimum server memory value (%d) must be less than or equal to the maximum value (%d). |
| 5904 | 17 | Background checkpoint process suspended until locks are available. |