MS SQL Server Error Types 2

Error Type =5001,/n Error Description User must be in the master database.. Error Severity  Level=16

Error Type =5002, Error Description Database '%.*ls' does not exist. Check sysdatabases.. Error Severity  Level=16

Error Type =5004, Error Description To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed.. Error Severity  Level=16

Error Type =5005, Error Description Extending database by %.2f MB on disk '%.*ls'.. Error Severity  Level=10

Error Type =5006, Error Description Could not get exclusive use of %S_MSG '%.*ls' to perform the requested operation.. Error Severity  Level=16

Error Type =5008, Error Description This ALTER DATABASE statement is not supported.. Error Severity  Level=16

Error Type =5009, Error Description 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.. Error Severity  Level=16

Error Type =5010, Error Description Log file name cannot be generated from a raw device. The log file name and path must be specified.. Error Severity  Level=16

Error Type =5011, Error Description User does not have permission to alter database '%.*ls'.. Error Severity  Level=14

Error Type =5012, Error Description The name of the primary filegroup cannot be changed.. Error Severity  Level=16

Error Type =5013, Error Description The master and model databases cannot have files added to them. ALTER DATABASE was aborted.. Error Severity  Level=16

Error Type =5014, Error Description The %S_MSG '%.*ls' does not exist in database '%.*ls'.. Error Severity  Level=16

Error Type =5015, Error Description ALTER DATABASE failed. The total size specified must be 1 MB or greater.. Error Severity  Level=16

Error Type =5016, Error Description System databases master, model, and tempdb cannot have their names changed.. Error Severity  Level=16

Error Type =5017, Error Description ALTER DATABASE failed. Database '%.*ls' was not created with 'FOR LOAD' option.. Error Severity  Level=16

Error Type =5018, Error Description File '%.*ls' modified in sysaltfiles. Delete old file after restarting SQL Server.. Error Severity  Level=0

Error Type =5019, Error Description Cannot find entry in sysaltfiles for file '%.*ls'.. Error Severity  Level=10

Error Type =5020, Error Description The primary data or log file cannot be removed from a database.. Error Severity  Level=16

Error Type =5021, Error Description The %S_MSG name '%.*ls' has been set.. Error Severity  Level=10

Error Type =5022, Error Description Log file '%ls' for this database is already active.. Error Severity  Level=16

Error Type =5023, Error Description Database must be put in bypass recovery mode to rebuild the log.. Error Severity  Level=16

Error Type =5024, Error Description No entry found for the primary log file in sysfiles1. Could not rebuild the log.. Error Severity  Level=16

Error Type =5025, Error Description The file '%ls' already exists. It should be renamed or deleted so that a new log file can be created.. Error Severity  Level=16

Error Type =5026, Error Description Could not create a new log file with file '%.*ls'. See previous errors.. Error Severity  Level=16

Error Type =5027, Error Description System databases master, model, and tempdb cannot have their logs rebuilt.. Error Severity  Level=16

Error Type =5028, Error Description The system could not activate enough of the database to rebuild the log.. Error Severity  Level=16

Error Type =5029, Error Description 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.. Error Severity  Level=10

Error Type =5030, Error Description The database could not be exclusively locked to perform the operation.. Error Severity  Level=16

Error Type =5031, Error Description Cannot remove the file '%.*ls' because it is the only file in the DEFAULT filegroup.. Error Severity  Level=16

Error Type =5032, Error Description The file cannot be shrunk below page %ud until the log is backed up because it contains bulk logged pages.. Error Severity  Level=10

Error Type =5035, Error Description Filegroup '%.*ls' already exists in this database.. Error Severity  Level=16

Error Type =5036, Error Description MODIFY FILE failed. Specify logical name.. Error Severity  Level=16

Error Type =5037, Error Description MODIFY FILE failed. Do not specify physical name.. Error Severity  Level=16

Error Type =5038, Error Description MODIFY FILE failed for file "%.*ls". At least one property per file must be specified.. Error Severity  Level=16

Error Type =5039, Error Description MODIFY FILE failed. Specified size is less than current size.. Error Severity  Level=16

Error Type =5040, Error Description MODIFY FILE failed. Size is greater than MAXSIZE.. Error Severity  Level=16

Error Type =5041, Error Description MODIFY FILE failed. File '%.*ls' does not exist.. Error Severity  Level=16

Error Type =5042, Error Description The %S_MSG '%.*ls' cannot be removed because it is not empty.. Error Severity  Level=16

Error Type =5043, Error Description The %S_MSG '%.*ls' cannot be found in %ls.. Error Severity  Level=16

Error Type =5044, Error Description The %S_MSG '%.*ls' has been removed.. Error Severity  Level=10

Error Type =5045, Error Description The %S_MSG already has the '%ls' property set.. Error Severity  Level=16

Error Type =5046, Error Description The %S_MSG property '%ls' has been set.. Error Severity  Level=10

Error Type =5047, Error Description Cannot change the READONLY property of the PRIMARY filegroup.. Error Severity  Level=16

Error Type =5048, Error Description Cannot add, remove, or modify files in filegroup '%.*ls'. The filegroup is read-only.. Error Severity  Level=16

Error Type =5049, Error Description Cannot extend file '%ls' using this syntax as it was not created with DISK INIT. Use ALTER DATABASE MODIFY FILE.. Error Severity  Level=16

Error Type =5050, Error Description Cannot change the properties of empty filegroup '%.*ls'. The filegroup must contain at least one file.. Error Severity  Level=16

Error Type =5051, Error Description Cannot have a filegroup with the name 'DEFAULT'.. Error Severity  Level=16

Error Type =5053, Error Description The maximum of %ld filegroups per database has been exceeded.. Error Severity  Level=16

Error Type =5054, Error Description Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle.. Error Severity  Level=16

Error Type =5055, Error Description Cannot add, remove, or modify file '%.*ls'. The file is read-only.. Error Severity  Level=16

Error Type =5056, Error Description Cannot add, remove, or modify a file in filegroup '%.*ls' because the filegroup is offline.. Error Severity  Level=16

Error Type =5057, Error Description Cannot add, remove, or modify file '%.*ls' because it is offline.. Error Severity  Level=16

Error Type =5058, Error Description Option '%.*ls' cannot be set in database '%.*ls'.. Error Severity  Level=16

Error Type =5059, Error Description Database '%.*ls' is in transition. Try the ALTER DATABASE statement later.. Error Severity  Level=16

Error Type =5060, Error Description Nonqualified transactions are being rolled back. Estimated rollback completion: %d%%.. Error Severity  Level=10

Error Type =5061, Error Description ALTER DATABASE failed because a lock could not be placed on database '%.*ls'. Try again later.. Error Severity  Level=16

Error Type =5062, Error Description Option '%.*ls' cannot be set at the same time as another option setting.. Error Severity  Level=16

Error Type =5063, Error Description Database '%.*ls' is in warm standby. A warm-standby database is read-only.. Error Severity  Level=16

Error Type =5064, Error Description Changes to the state or options of database '%.*ls' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.. Error Severity  Level=16

Error Type =5065, Error Description Database '%.*ls' cannot be opened.. Error Severity  Level=16

Error Type =5066, Error Description Database options single user and dbo use only cannot be set at the same time.. Error Severity  Level=16

Error Type =5068, Error Description Failed to restart the current database. The current database is switched to master.. Error Severity  Level=10

Error Type =5069, Error Description ALTER DATABASE statement failed.. Error Severity  Level=16

Error Type =5070, Error Description Database state cannot be changed while other users are using the database '%.*ls'. Error Severity  Level=16

Error Type =5072, Error Description ALTER DATABASE failed. The default collation of database '%.*ls' cannot be set to %.*ls.. Error Severity  Level=16

Error Type =5073, Error Description Cannot alter collation for database '%ls' because it is READONLY, OFFLINE, or marked SUSPECT.. Error Severity  Level=16

Error Type =5074, Error Description The 'Primary Key Constraint Name' is dependent on 'Primary Key Column Name'.. Error Severity  Level=16

Error Type =5075, Error Description The %S_MSG '%.*ls' is dependent on %S_MSG.. Error Severity  Level=16

Error Type =5076, Error Description Warning: Changing default collation for database '%.*ls', which is used in replication. It is recommend that all replication database have the same default collation.. Error Severity  Level=10

Error Type =, Error Description The Publisher could not be created at this time.. Error Severity  Level=16

Error Type =Error, Error Description Description. Error Severity  Level=Severity

Error Type =5101, Error Description You must supply parameters for the DISK %hs statement. Usage: %hs.. Error Severity  Level=15

Error Type =5102, Error Description No such statement DISK %.*ls.. Error Severity  Level=15

Error Type =5103, Error Description MAXSIZE cannot be less than SIZE for file '%ls'.. Error Severity  Level=16

Error Type =5104, Error Description File '%.*ls' already used.. Error Severity  Level=16

Error Type =5105, Error Description Device activation error. The physical file name '%.*ls' may be incorrect.. Error Severity  Level=16

Error Type =5106, Error Description Parameter '%hs' requires value of data type '%hs'.. Error Severity  Level=15

Error Type =5107, Error Description Value is wrong data type for parameter '%hs' (requires data type '%hs').. Error Severity  Level=15

Error Type =5108, Error Description Log file '%.*ls' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.. Error Severity  Level=10

Error Type =5109, Error Description No such parameter '%.*ls'.. Error Severity  Level=16

Error Type =5110, Error Description File '%.*ls' is on a network device not supported for database files.. Error Severity  Level=16

Error Type =5116, Error Description You do not have permission to run DISK statements.. Error Severity  Level=14

Error Type =5117, Error Description Could not run DISK statement. You must be in the master database to run this statement.. Error Severity  Level=16

Error Type =5122, Error Description Each disk file size must be greater than or equal to 1 MB.. Error Severity  Level=10

Error Type =5123, Error Description CREATE FILE encountered operating system error %ls while attempting to open or create the physical file '%.*ls'.. Error Severity  Level=16

Error Type =5126, Error Description The logical device '%.*ls' does not exist in sysdevices.. Error Severity  Level=16

Error Type =5146, Error Description The %hs of %d is out of range. It must be between %d and %d.. Error Severity  Level=16

Error Type =5148, Error Description Could not set the file size to the desired amount. The operating system file size limit may have been reached.. Error Severity  Level=16

Error Type =5149, Error Description MODIFY FILE encountered operating system error %ls while attempting to expand the physical file.. Error Severity  Level=16

Error Type =5150, Error Description The size of a single log file must not be greater than 2 TB.. Error Severity  Level=16

Error Type =5151, Error Description The %hs statement is obsolete and no longer supported.. Error Severity  Level=16

Error Type =5157, Error Description I/O error encountered in the writelog system function during backout.. Error Severity  Level=16

Error Type =5158, Error Description Warning: Media in device '%.*ls' may have been changed.. Error Severity  Level=10

Error Type =5159, Error Description Operating system error %.*ls on device '%.*ls' during %ls.. Error Severity  Level=16

Error Type =5160, Error Description Cannot take '%.*ls' offline because the database is in use.. Error Severity  Level=16

Error Type =5162, Error Description Cannot find '%.*ls' in sysdatabases.. Error Severity  Level=16

Error Type =5163, Error Description Cannot open '%.*ls' to take offline.. Error Severity  Level=16

Error Type =5164, Error Description Usage: DBCC DBCONTROL(dbname,ONLINE|OFFLINE). Error Severity  Level=16

Error Type =5165, Error Description Cannot explicitly open or close master database.. Error Severity  Level=16

Error Type =5167, Error Description Database '%.*ls' is already offline.. Error Severity  Level=16

Error Type =5168, Error Description File '%.*ls' is on a network drive, which is not allowed.. Error Severity  Level=16

Error Type =5169, Error Description FILEGROWTH cannot be greater than MAXSIZE for file '%.*ls'.. Error Severity  Level=16

Error Type =5170, Error Description Cannot create file '%ls' because it already exists.. Error Severity  Level=16

Error Type =5171, Error Description %.*ls is not a primary database file.. Error Severity  Level=16

Error Type =5172, Error Description The header for file '%ls' is not a valid database file header. The %ls property is incorrect.. Error Severity  Level=16

Error Type =5173, Error Description Cannot associate files with different databases.. Error Severity  Level=16

Error Type =5174, Error Description Each file size must be greater than or equal to 512 KB.. Error Severity  Level=10

Error Type =5175, Error Description The file '%.*ls' has been expanded to prevent recovery from failing. Contact the system administrator for further assistance.. Error Severity  Level=10

Error Type =5176, Error Description The file '%.*ls' has been expanded beyond its maximum size to prevent recovery from failing. Contact the system administrator for further assistance.. Error Severity  Level=10

Error Type =5177, Error Description Encountered an unexpected error while checking the sector size for file '%.*ls'. Check the SQL Server error log for more information.. Error Severity  Level=16

Error Type =5178, Error Description Cannot use file '%.*ls' because it was originally formatted with sector size %d and is now on a device with sector size %d.. Error Severity  Level=16

Error Type =5179, Error Description Cannot use file '%.*ls', which is on a device with sector size %d. SQL Server supports a maximum sector size of 4096 bytes.. Error Severity  Level=16

Error Type =5180, Error Description Could not open FCB for invalid file ID %d in database '%.*ls'.. Error Severity  Level=22

Error Type =5181, Error Description Could not restart database '%.*ls'. Reverting back to old status.. Error Severity  Level=16

Error Type =5182, Error Description New log file '%.*ls' was created.. Error Severity  Level=16

Error Type =5183, Error Description File '%ls' cannot be created. Use WITH MOVE to specify a usable physical file name.. Error Severity  Level=16

Error Type =5184, Error Description Cannot use file '%.*ls' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.. Error Severity  Level=16

Error Type =5701, Error Description Changed database context to '%.*ls'.. Error Severity  Level=10

Error Type =5702, Error Description SQL Server is terminating this process.. Error Severity  Level=10

Error Type =5703, Error Description Changed language setting to %.*ls.. Error Severity  Level=10

Error Type =5803, Error Description Unknown config number (%d) in sysconfigures.. Error Severity  Level=10

Error Type =5804, Error Description Character set, sort order, or collation cannot be changed because at least one database is not writable.. Error Severity  Level=16

Error Type =5805, Error Description Too few locks specified. Minimum %d.. Error Severity  Level=16

Error Type =5807, Error Description Recovery intervals above %d minutes not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.. Error Severity  Level=16

Error Type =5808, Error Description Ad hoc updates to system catalogs not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.. Error Severity  Level=16

Error Type =5809, Error Description Average time slices above %d milliseconds not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.. Error Severity  Level=16

Error Type =5810, Error Description Valid values for the fill factor are 0 to 100.. Error Severity  Level=16

Error Type =5812, Error Description You do not have permission to run the RECONFIGURE statement.. Error Severity  Level=14

Error Type =5823, Error Description Cannot reconfigure SQL Server to use sort order ID %d, because the row for that sort order does not exist in syscharsets.. Error Severity  Level=16

Error Type =5828, Error Description User connections are limited to %d.. Error Severity  Level=16

Error Type =5829, Error Description The specified user options value is invalid.. Error Severity  Level=16

Error Type =5830, Error Description The default collation for SQL Server has been reconfigured. Restart SQL Server to rebuild the table indexes on columns of character data types.. Error Severity  Level=10

Error Type =5831, Error Description Minimum server memory value (%d) must be less than or equal to the maximum value (%d).. Error Severity  Level=16

Error Type =5904, Error Description Background checkpoint process suspended until locks are available.. Error Severity  Level=17