Share via


Errors 5000 - 5999

Error

Severity

Event Logged

Description (Message Text)

5001

16

No

User must be in the master database.

5002

16

No

Database '%.*ls' does not exist. Verify the name in sys.databases and try the operation again.

5003

16

No

Database mirroring cannot be enabled while the database has offline files.

5004

16

No

To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed.

5006

16

No

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

5008

16

No

This ALTER DATABASE statement is not supported. Correct the syntax and execute the statement again.

5009

16

No

One or more files listed in the statement could not be found or could not be initialized.

5010

16

No

Log file name cannot be generated from a raw device. The log file name and path must be specified.

5011

14

No

User does not have permission to alter database '%.*ls', the database does not exist, or the database is not in a state that allows access checks.

5012

16

No

The name of the primary filegroup cannot be changed.

5013

16

No

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

5014

16

No

The %S_MSG '%.*ls' does not exist in database '%.*ls'.

5015

16

No

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

5016

16

No

Cannot change the name of the system database %.*ls.

5018

10

No

The file "%.*ls" has been modified in the system catalog. The new path will be used the next time the database is started.

5019

10

No

Cannot find entry in sys.master_files for file '%.*ls'.

5020

16

No

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

5021

10

No

The %S_MSG name '%.*ls' has been set.

5022

16

No

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

5023

16

No

The database must be suspect or in emergency mode to rebuild the log.

5024

16

No

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

5025

16

No

The file '%ls' already exists. It should be renamed or deleted so that a new log file can be created.

5027

16

No

System databases master, model, and tempdb cannot have their logs rebuilt.

5028

16

No

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

5029

10

Yes

Warning: The log for database '%.*ls' has been rebuilt. Transactional consistency has been lost. The RESTORE chain was broken, and the server no longer has context on the previous log files, so you will need to know what they were. You should run DBCC CHECKDB to validate physical consistency. The database has been put in dbo-only mode. When you are ready to make the database available for use, you will need to reset database options and delete any extra log files.

5030

16

No

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

5031

16

No

Cannot remove the file '%.*ls' because it is the only file in the DEFAULT filegroup.

5032

10

No

The file cannot be shrunk below page %ud until the log is backed up because it contains bulk logged pages.

5033

16

No

The maximum of %ld files per database has been exceeded.

5034

16

No

The file %ls is currently being autogrown or modified by another process. Try the operation again later.

5035

16

No

Filegroup '%.*ls' already exists in this database. Specify a different name or remove the conflicting filegroup if it is empty.

5036

16

No

MODIFY FILE failed. Specify logical name.

5038

16

No

MODIFY FILE failed for file "%.*ls". At least one property per file must be specified.

5039

16

No

MODIFY FILE failed. Specified size is less than or equal to current size.

5040

16

No

MODIFY FILE failed. Size is greater than MAXSIZE.

5041

16

No

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

5042

16

No

The %S_MSG '%.*ls' cannot be removed because it is not empty.

5043

16

No

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

5044

10

No

The %S_MSG '%.*ls' has been removed.

5045

16

No

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

5046

10

No

The %S_MSG property '%ls' has been set.

5047

16

No

Cannot change the READONLY property of the PRIMARY filegroup.

5048

16

No

Cannot add, remove, or modify files in filegroup '%.*ls'. The filegroup is read-only.

5050

16

No

Cannot change the properties of empty filegroup '%.*ls'. The filegroup must contain at least one file.

5051

16

No

Cannot have a filegroup with the name 'DEFAULT'.

5052

16

No

%ls is not permitted while a database is in the %ls state.

5054

16

No

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

5055

16

No

Cannot add, remove, or modify file '%.*ls'. The file is read-only.

5056

16

No

Cannot add, remove, or modify a file in filegroup '%.*ls' because the filegroup is not online.

5057

16

No

Cannot add, remove, or modify file '%.*ls' because it is offline.

5058

16

No

Option '%.*ls' cannot be set in database '%.*ls'.

5059

16

No

Database '%.*ls' is in transition. Try the ALTER DATABASE statement later.

5060

10

No

Nonqualified transactions are being rolled back. Estimated rollback completion: %d%%.

5061

16

No

ALTER DATABASE failed because a lock could not be placed on database '%.*ls'. Try again later.

5062

16

No

The option "%.*ls" conflicts with another requested option. The options cannot both be requested at the same time.

5063

16

No

Database '%.*ls' is in warm standby. A warm-standby database is read-only.

5064

16

No

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.

5065

16

No

The file "%ls" is currently being scanned or used by a background or user process. Try the operation again later.

5066

16

No

Database options single user and dbo use only cannot be set at the same time.

5067

16

No

The database option TORN_PAGE_DETECTION is incompatible with the PAGE_CHECKSUM option.

5068

10

No

Failed to restart the current database. The current database is switched to master.

5069

16

No

ALTER DATABASE statement failed.

5070

16

No

Database state cannot be changed while other users are using the database '%.*ls'

5071

16

No

Rebuild log can only specify one file.

5072

16

No

ALTER DATABASE failed. The default collation of database '%.*ls' cannot be set to %.*ls.

5073

16

No

Cannot alter collation for database '%ls' because it is READONLY, OFFLINE, or marked SUSPECT.

5074

16

No

The %S_MSG '%.*ls' is dependent on %S_MSG '%.*ls'.

5075

16

No

The %S_MSG '%.*ls' is dependent on %S_MSG. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

5076

10

No

Warning: Changing default collation for database '%.*ls', which is used in replication. All replication databases should have the same default collation.

5077

16

No

Cannot change the state of non-data files or files in the primary filegroup.

5078

16

No

Cannot alter database options for "%ls" because it is READONLY, OFFLINE, or marked SUSPECT.

5079

10

No

Database "%.*ls" is %S_MSG for vardecimal storage format.

5080

16

No

Vardecimal storage format cannot be disabled for database "%.*ls" because the database is not under simple recovery model. Change the database recovery model to simple and then reissue the command.

5082

16

No

Cannot change the versioning state on database "%.*ls" together with another database state.

5083

16

No

The termination option is not supported when making versioning state changes.

5084

10

Yes

Setting database option %ls to %ls for database %.*ls.

5085

16

No

Alter database command failed because SQL Server was started with one or more undocumented trace flags that prevent enabling/disabling database for versioning.

5086

16

No

Cannot disable vardecimal storage format for database "%.*ls" because there are one or more tables that have vardecimal storage format enabled. Disable the vardecimal storage format on all tables before disabling the vardecimal storage format for the database.

5087

16

No

The file content type mismatches with the content type of the filegroup.

5088

16

No

Change tracking is already enabled for database '%.*ls'.

5089

16

No

Change tracking is disabled for database '%.*ls'. Change tracking must be enabled on a database to modify change tracking settings.

5090

16

No

Database '%.*ls' is a system database. Change tracking settings cannot be modified for system databases.

5091

15

No

ALTER DATABASE change tracking option '%ls' was specified more than once. Each option can be specified only once.

5092

15

No

The value for change tracking option '%ls' is not valid. The value must be between %d and %d minutes.

5093

16

No

The operation cannot be performed on a database snapshot.

5094

16

No

The operation cannot be performed on a database with database snapshots or active DBCC replicas.

5095

16

No

A database or filegroup cannot be set to read-only mode when any files are subject to a RESTORE PAGE operation. Complete the restore sequence involving file "%ls" before attempting to transition to read-only.

5096

16

No

The recovery model cannot be changed to SIMPLE when any files are subject to a RESTORE PAGE operation. Complete the restore sequence involving file "%ls" before attempting to transition to SIMPLE.

5097

16

No

The container cannot be set to the offline state because changes exist that require a log backup. Take a log backup and then retry the ALTER DATABASE statement.

5098

16

No

The container can not be dropped because changes exist that require a log backup. Take a log backup and then retry the ALTER DATABASE operation.

5099

16

No

ALTER DATABASE failed because the READ_COMMITTED_SNAPSHOT and the ALLOW_SNAPSHOT_ISOLATION options cannot be set to ON when a database has FILESTREAM filegroups. To set READ_COMMITTED_SNAPSHOT or ALLOW_SNAPSHOT_ISOLATION to ON, you must remove the FILESTREAM filegroups from the database.

5102

22

No

Attempted to open a filegroup for the invalid ID %d in database "%.*ls".

5103

16

No

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

5104

16

No

File '%.*ls' already used.

5105

16

Yes

A file activation error occurred. The physical file name '%.*ls' may be incorrect. Diagnose and correct additional errors, and retry the operation.

5108

10

No

Log file '%.*ls' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.

5110

16

No

The file "%.*ls" is on a network path that is not supported for database files.

5111

10

No

File activation failure. The physical file name "%.*ls" may be incorrect.

5112

10

Yes

FCB::SetSize dbid %d fileid %d oldSize %d newSize %d. To prevent this informational message from appearing in the error log, use DBCC TRACEOFF to turn off the trace flag.

5113

10

No

The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.

5114

16

No

Log files, offline files, restoring files, and defunct files for database snapshots should not be specified. "%.*ls" is not an eligible file for a database snapshot.

5115

16

No

Only SQL Server database files can be specified for database snapshots. '%.*ls' is not a SQL Server database file.

5118

16

No

The file "%ls" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

5119

16

No

Cannot make the file "%.*ls" a sparse file. Make sure the file system supports sparse files.

5120

16

No

Unable to open the physical file "%.*ls". Operating system error %d: "%ls".

5121

16

No

The path specified by "%.*ls" is not in a valid directory.

5123

16

No

CREATE FILE encountered operating system error %ls while attempting to open or create the physical file '%.*ls'.

5124

16

Yes

The file header in '%ls' does not match the expected contents for file '%ls' of database '%ls'. The mismatch is possibly between the full-text catalog files and the related database. Perform a restore if necessary.

5125

24

No

File '%ls' appears to have been truncated by the operating system. Expected size is %I64d KB but actual size is %I64d KB.

5127

16

No

All files must be specified for database snapshot creation. Missing the file "%ls".

5128

17

No

Write to sparse file '%ls' failed due to lack of disk space.

5129

10

No

The log cannot be rebuilt when the primary file is read-only.

5130

10

No

The log cannot be rebuilt when database mirroring is enabled.

5131

10

No

The log was not rebuilt because there is more than one log file.

5132

16

No

The path specified by '%.*ls' cannot be used for FILESTREAM files because it is a raw device.

5133

16

No

Directory lookup for the file "%ls" failed with the operating system error %ls.

5134

16

No

The path that is specified by '%.*ls' cannot be used for FILESTREAM files because it is not on a supported file system.

5135

16

No

The path '%.*ls' cannot be used for FILESTREAM files. For information about supported paths, see SQL Server Books Online.

5136

16

No

The path specified by '%.*ls' cannot be used for a FILESTREAM container since it is contained in another FILESTREAM container.

5144

10

Yes

Autogrow of file '%.*ls' in database '%.*ls' was cancelled by user or timed out after %d milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.

5145

10

Yes

Autogrow of file '%.*ls' in database '%.*ls' took %d milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

5149

16

No

MODIFY FILE encountered operating system error %ls while attempting to expand the physical file '%ls'.

5150

16

No

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

5159

24

No

Operating system error %.*ls on file "%.*ls" during %ls.

5161

16

Yes

An unexpected file id was encountered. File id %d was expected but %d was read from "%.*ls". Verify that files are mapped correctly in sys.master_files. ALTER DATABASE can be used to correct the mappings.

5169

16

No

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

5170

16

Yes

Cannot create file '%ls' because it already exists. Change the file path or the file name, and retry the operation.

5171

16

No

%.*ls is not a primary database file.

5172

16

No

The header for file '%ls' is not a valid database file header. The %ls property is incorrect.

5173

16

Yes

One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.

5174

16

No

Each file size must be greater than or equal to 512 KB.

5175

10

Yes

The file %.*ls has been expanded to allow recovery to succeed. After recovery completes, you can increase the size of the files in the database. Contact the system administrator for assistance.

5176

10

Yes

To allow recovery to succeed, the log file '%.*ls' has been expanded beyond its maximum size. After recovery completes, you should either increase the size of the log file in the database or schedule more frequent backups of the log (under the full or bulk-logged recovery model).

5177

16

Yes

An unexpected error occurred while checking the sector size for file '%.*ls'. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information.

5178

16

Yes

Cannot use file '%.*ls' because it was originally formatted with sector size %d and is now on a volume with sector size %d. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.

5179

16

Yes

Cannot use file '%.*ls', because it is on a volume with sector size %d. SQL Server supports a maximum sector size of 4096 bytes. Move the file to a volume with a compatible sector size.

5180

22

Yes

Could not open File Control Bank (FCB) for invalid file ID %d in database '%.*ls'. Verify the file location. Execute DBCC CHECKDB.

5181

16

No

Could not restart database "%.*ls". Reverting to the previous status.

5182

10

Yes

New log file '%.*ls' was created.

5183

16

No

Cannot create the file "%ls". Use WITH MOVE to specify a usable physical file name. Use WITH REPLACE to overwrite an existing file.

5184

16

No

Cannot use file '%.*ls' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

5185

16

No

Cannot find the matching log file for FILESTRAM file '%.*ls'.

5186

16

No

Encountered an error (NT status code 0x%x) while attempting to start the Transactional File System Resource Manager '%.*ls'.

5188

16

No

Encountered error (NT status code 0x%x) while attempting to perform redo for transactional file system resource manager '%.*ls'.

5189

16

No

Encountered error (NT status code 0x%x) while attempting to perform undo for transactional file system resource manager '%.*ls'.

5190

16

No

Encountered error (NT status code 0x%x) while attempting to checkpoint transactional file system resource manager '%.*ls'.

5194

16

No

The size for FILESTREAM log file '%.*ls' must be greater than or equal to 1 MB.

5195

16

No

The Cluster Service function call '%s' failed with error code '%s' while verifying the file path. Verify that your failover cluster is configured properly.

5196

10

No

The file "%ls" has been uncompressed.

5197

16

No

Encountered an error (%ls) while attempting to uncompress the file "%ls".

5198

16

No

The path specified by "%.*ls" is a UNC path. UNC path is not supported in failover clustered environment.

5199

16

No

The path specified by "%.*ls" is a raw device. Raw device path is not supported in failover clustered environment.

5201

10

No

DBCC SHRINKDATABASE: File ID %d of database ID %d was skipped because the file does not have enough free space to reclaim.

5202

10

No

DBCC SHRINKDATABASE for database ID %d is waiting for the snapshot transaction with timestamp %I64d and other snapshot transactions linked to timestamp %I64d or with timestamps older than %I64d to finish.

5203

10

No

DBCC SHRINKFILE for file ID %d is waiting for the snapshot transaction with timestamp %I64d and other snapshot transactions linked to timestamp %I64d or with timestamps older than %I64d to finish.

5204

16

No

Could not find allocation unit ID %I64d. Check sys.allocation_units.

5205

10

No

%.*ls: Moving page %d:%d failed.

5206

10

No

%.*ls: Page %d:%d could not be moved because it could not be read.

5207

10

No

%.*ls: Page %d:%d could not be moved because it is a work table page.

5208

10

No

%.*ls: Page %d:%d could not be moved because it is a work file page.

5209

10

No

%.*ls: Page %d:%d could not be moved because it is a dedicated allocation page.

5210

10

No

%.*ls: Page %d:%d could not be moved because it is an invalid page type.

5211

10

No

%.*ls: Page %d:%d could not be moved because it was deallocated during shrink.

5212

10

No

%.*ls: System table SYSFILES1 Page %d:%d could not be moved to other files because it only can reside in the primary file of the database.

5213

10

No

%.*ls: Page %d:%d could not be moved because its ownership was changed during shrink.

5214

10

No

%.*ls: Page %d:%d could not be moved because its page type was changed during shrink.

5215

10

No

%.*ls: Page %d:%d could not be moved because the partition to which it belonged was dropped.

5216

10

No

%.*ls: Heap page %d:%d could not be moved because the table to which it belonged was dropped.

5217

10

No

%.*ls: Page %d:%d could not be moved because it is an empty non-leaf level index page.

5218

10

No

%.*ls: Heap page %d:%d could not be moved because the table name could not be found.

5219

10

No

%.*ls: Heap page %d:%d could not be moved.

5220

10

No

%.*ls: Index Allocation Map (IAM) page %d:%d could not be moved.

5221

10

No

%.*ls: Index Allocation Map (IAM) page %d:%d from a dropped allocation unit could not be moved.

5222

10

No

%.*ls: Page %d:%d from a dropped allocation unit could not be deallocated.

5223

10

No

%.*ls: Empty page %d:%d could not be deallocated.

5224

10

No

%.*ls: Empty large object page %d:%d could not be deallocated.

5225

10

No

%.*ls: Not all ghost records on the large object page %d:%d could be removed.

5226

10

No

%.*ls: Page %d:%d (type UNLINKED_REORG_PAGE) could not be deallocated.

5227

10

No

%.*ls: Page %d:%d (type BULK_OPERATION_PAGE) could not be deallocated.

5228

16

No

Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d. DBCC detected incomplete cleanup from an online index build operation. (The anti-matter column value is %d.)

5229

16

No

Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) contains an anti-matter column, but is not a nonclustered index.

5230

10

No

The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.

5231

10

No

Object ID %ld (object '%.*ls'): A deadlock occurred while trying to lock this object for checking. This object has been skipped and will not be processed.

5232

10

No

DBCC CHECKDB will not check SQL Server catalog or Service Broker consistency because a database snapshot could not be created or because WITH TABLOCK was specified.

5233

16

No

Table error: alloc unit ID %I64d, page %S_PGID. The test (%hs) failed. The values are %ld and %ld.

5234

10

No

DBCC SHRINKDATABASE: File ID %d of database ID %d was skipped because trying to adjust the space allocation for the file was failed.

5235

10

No

%lsDBCC %ls (%ls%ls%ls)%ls executed by %ls terminated abnormally due to error state %d. Elapsed time: %d hours %d minutes %d seconds.

5236

10

No

Unable to process object '%ls' because it is a four-part name, which is not supported by any DBCC command.

5237

10

No

DBCC cross-rowset check failed for object '%.*ls' (object ID %d) due to an internal query error.

5238

16

No

Unable to process object ID %ld (object '%.*ls') because it is a stored procedure or user-defined function, which is not supported by any DBCC command.

5239

16

No

Unable to process object ID %ld (object '%.*ls') because this DBCC command does not support objects of this type.

5240

10

No

File ID %d of database ID %d cannot be shrunk as it is either being shrunk by another process or is empty.

5241

10

No

File ID %d of database ID %d cannot be shrunk as the target shrink size (%I64d KB) is greater than the actual file size (%I64d KB).

5242

16

No

An inconsistency was detected during an internal operation in database '%.*ls'(ID:%d) on page %S_PGID. Please contact technical support.

5243

16

No

An inconsistency was detected during an internal operation. Please contact technical support.

5244

16

No

Repair statement not processed. One or more files in the database are read-only and must be made writeable in order to run repair.

5245

16

No

Object ID %ld (object '%.*ls'): DBCC could not obtain a lock on this object because the lock request timeout period was exceeded. This object has been skipped and will not be processed.

5246

16

No

Repair operations cannot be performed on the MSSQLSYSTEMRESOURCE database. Consult Books Online topic "Resource Database" for more information.

5247

16

No

Repair: insert a secondary index row based on its base table row.

5248

10

No

Repair: Successfully %ls row in index "%ls" in database "%ls".

5249

10

No

%.*ls: Page %d:%d could not be moved because shrink could not lock the page.

5250

16

No

Database error: %ls page %S_PGID for database '%.*ls' (database ID %d) is invalid. This error cannot be repaired. You must restore from backup.

5251

10

No

%.*ls: Heap page %d:%d could not be moved because maintaining NC indexes associated with the heap failed.

5252

10

No

File ID %d of database ID %d cannot be shrunk to the expected size. The high concurrent workload is leading to too many deadlocks during the shrink operation. Re-run the shrink operation when the workload is lower.

5253

10

No

The check statement was aborted. DBCC CHECKALLOC cannot be run on TEMPDB.

5254

10

No

%.*ls: Heap page %d:%d could not be moved because the table to which it belonged was building the heap by another process.

5255

10

No

%.*ls: Page %d:%d could not be moved because it is a sort page.

5256

16

No

Table error: alloc unit ID %I64d, page %S_PGID contains an incorrect page ID in its page header. The PageId in the page header = %S_PGID.

5257

10

No

%.*ls: File ID %d of database ID %d was skipped because the file size was changed in the middle of shrink operation.

5258

10

No

%.*ls: Heap page %d:%d could not be moved because building computed column expression failed.

5259

10

No

%.*ls: Heap page %d:%d could not be moved because populating computed column expression failed.

5260

16

No

Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls): At least one record on page %S_PGID contains versioning information, but the VERSION_INFO bit in the page header is not set.

5261

10

No

%.*ls: Page %d:%d could not be moved because it has not been formatted.

5262

16

No

Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d: Row contains a NULL versioning timestamp, but its version chain pointer is not NULL. Version chain points to page %S_PGID, slot %d.

5263

10

No

Found incorrect count(s) for table '%.*ls', index '%.*ls', partition %ld:

5264

10

No

DATA pages %.*ls: From system table - %I64d pages; Actual - %I64d pages.

5265

10

No

USED pages %.*ls: From system table - %I64d pages; Actual - %I64d pages.

5266

10

No

RSVD pages %.*ls: From system table - %I64d pages; Actual - %I64d pages.

5267

10

No

ROWS count: From system table - %I64d rows; Actual - %I64d rows.

5268

10

No

DBCC %.*ls is performing an exhaustive search of %d indexes for possible inconsistencies. This is an informational message only. No user action is required.

5269

16

No

Check terminated. The transient database snapshot for database '%.*ls' (database ID %d) has been marked suspect due to an IO operation failure. Refer to the SQL Server error log for details.

5270

10

No

%.*ls: Page %d:%d could not be moved because it is an unmovable page in a critical system table.

5271

10

No

DBCC %ls could not output results for this command due to an internal failure. Review other errors for details.

5272

10

No

%.*ls: Index Allocation Map (IAM) page %d:%d could not be moved because the underlying object could not be accessed exclusively.

5273

10

No

%.*ls: Page %d:%d could not be moved because it belonged to an index/heap that was/is in build online.

5274

16

No

Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID. %S_MSG is invalid for compressed page; the following internal test failed: %hs. Values are %ld and %ld.

5275

10

No

Exhaustive search of '%.*ls' (database ID %d) for inconsistencies completed. Processed %d of %d total searches. Elapsed time: %I64d milliseconds. This is an informational message only. No user action is required.

5276

10

No

Exhaustive search of '%.*ls' (database ID %d) for inconsistencies failed due to exception %d, state %d. This is an informational message only. No user action is required.

5277

10

No

Internal %lsdatabase snapshot has split point LSN = %08x:%08x:%04x and first LSN = %08x:%08x:%04x. This is an informational message only. No user action is required.

5301

16

No

Bulk load failed. User does not have ALTER TABLE permission on table '%.*ls'. ALTER TABLE permission is required on the target table of a bulk load if the target table contains triggers or check constraints, but the 'FIRE_TRIGGERS' or 'CHECK_CONSTRAINTS' bulk hints are not specified. ALTER TABLE permission is also required if the 'KEEPIDENTITY' bulk hint is specified.

5302

16

No

Mutator '%.*ls' on '%.*ls' cannot be called on a null value.

5303

16

No

The result of applying mutator '%.*ls' on CLR type '%.*ls' cannot be a null value.

5304

16

No

Bulk copy failed. User does not have ALTER TABLE permission on table '%.*ls'. ALTER TABLE permission is required on the target table of a bulk copy operation if the table has triggers or check constraints, but 'FIRE_TRIGGERS' or 'CHECK_CONSTRAINTS' bulk hints are not specified as options to the bulk copy command.

5305

16

No

The rowdump and lockres columns are only valid on tables and indexed views on which the NOEXPAND hint is specified.

5306

16

No

Cursor parameters are not allowed for functions. Variable '%.*ls' is of type cursor.

5307

16

No

Invalid parameter specified for sp_cursoropen.

5308

16

No

Windowed functions do not support integer indices as ORDER BY clause expressions.

5309

16

No

Windowed functions do not support constants as ORDER BY clause expressions.

5310

16

No

Aggregates are not allowed in the VALUES list of an INSERT statement.

5311

16

No

Invalid quote character '%lc'. A remote server or user command used an invalid quote character.

5312

16

No

The input to the function 'ntile' cannot be bound.

5313

16

No

Synonym '%.*ls' refers to an invalid object.

5315

16

No

The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.

5316

16

No

The target '%.*ls' of the MERGE statement has an INSTEAD OF trigger on some, but not all, of the actions specified in the MERGE statement. In a MERGE statement, if any action has an enabled INSTEAD OF trigger on the target, then all actions must have enabled INSTEAD OF triggers.

5317

16

No

The target of a MERGE statement cannot be a partitioned view.

5318

16

No

In a MERGE statement, the source and target cannot have the same name or alias. Use different aliases for the source and target to ensure that they have unique names in the MERGE statement.

5319

16

No

Aggregates are not allowed in a WHEN clause of a MERGE statement.

5321

16

No

The '%ls' function is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

5322

16

No

An aggregate function is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

5323

15

No

Subqueries are not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

5324

15

No

In a MERGE statement, a '%S_MSG' clause with a search condition cannot appear after a '%S_MSG' clause with no search condition.

5325

15

No

The order of the data in the data file does not conform to the ORDER hint specified for the BULK rowset '%.*ls'. The order of the data must match the order specified in the ORDER hint for a BULK rowset. Update the ORDER hint to reflect the order in which the input data is ordered, or update the input data file to match the order specified by the ORDER hint.

5326

15

No

The data in the data file does not conform to the UNIQUE hint specified for the BULK rowset '%.*ls'. The data in the data file must be unique if the UNIQUE hint is specified for a BULK rowset. Remove the UNIQUE hint, or update the input data file to ensure that the data is unique.

5327

15

No

The column '%.*ls' does not have a valid data type for the ORDER hint specified for data source '%.*ls'. The text, ntext, image, xml, varchar(max), nvarchar(max) and varbinary(max) data types cannot be used in the ORDER hint for a BULK rowset or CLR TVF.

5328

15

No

Cannot insert explicit value for the identity column '%.*ls' in the target table '%.*ls' of the INSERT statement when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

5329

15

No

Windowed functions are not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

5330

16

No

Full-text predicates cannot appear in the OUTPUT clause.

5331

16

No

Full-text predicates cannot appear in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

5332

15

No

The order of the data in the stream does not conform to the ORDER hint specified for the CLR TVF '%.*ls'. The order of the data must match the order specified in the ORDER hint for a CLR TVF. Update the ORDER hint to reflect the order in which the input data is ordered, or update the CLR TVF to match the order specified by the ORDER hint.

5333

16

No

The identifier '%.*ls' cannot be bound. Only source columns are allowed in the 'WHEN NOT MATCHED' clause of a MERGE statement.

5334

16

No

The identifier '%.*ls' cannot be bound. Only target columns are allowed in the 'WHEN NOT MATCHED BY SOURCE' clause of a MERGE statement.

5501

16

No

The FILESTREAM filegroup was dropped before the table can be created.

5502

16

No

The FILESTREAM container is inaccessible.

5503

10

No

Unable to find entry in sys.database_files for FILESTREAM file '%.*ls'.

5504

15

No

'PRIMARY' can only be specified for FILESTREAM log filegroup in a 'CONTAINS' clause.

5505

16

No

A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column.

5506

15

No

FILESTREAM data or log file cannot be named 'DEFAULT'.

5507

15

No

DEFAULT cannot be specified for FILESTREAM log filegroup '%.*ls'.

5508

15

No

FILESTREAM can only be declared for VARBINARY columns.

5509

15

No

The properties SIZE, MAXSIZE, or FILEGROWTH cannot be specified for the FILESTREAM data file '%.*ls'.

5510

15

No

LOG ON cannot be used for non-FILESTREAM file group '%.*ls'.

5511

23

No

FILESTREAM's file system log record '%.*ls' under log folder '%.*ls' is corrupted.

5512

16

Yes

Error 0x%x (%ls) was encountered while directory '%.*ls' was being truncated.

5513

16

No

The name that is specified for the associated log filegroup for FILESTREAM filegroup '%.*ls' is not valid.

5514

16

No

Transactional replication/Change Data Capture cannot proceed because Transactional File System Resource Manager at '%.*ls' is not started.

5515

20

No

Cannot open the container directory '%.*ls' of the FILESTREAM file. The operating system has returned the Windows status code 0x%x.

5516

16

No

The FILESTREAM log filegroup '%.*ls' cannot be referred to by more than one FILESTREAM data filegroup.

5517

16

No

Too few or too many files specified for FILESTREAM(LOG) filegroup '%.*ls'.

5518

16

No

FILESTREAM path '%.*ls' is too long.

5519

16

No

A database must have primary FILESTREAM log filegroup and log file in order for it to contain other FILESTREAM filegroups.

5520

16

No

FILESTREAM file '%.*ls' cannot be added because its destination filegroup cannot have more than one file.

5521

16

No

Error 0x%x (NT status code) was encountered when SQL Server attempts to retrieve '%.*ls' from the Transaction File System Resource Manager located at '%.*ls'.

5522

16

No

FILESTREAM data file cannot be removed because its log file has not been backed up.

5523

16

No

FILESTREAM data file group cannot be added to refer to an empty FILESTREAM log file group.

5524

16

No

Default FILESTREAM data filegroup cannot be removed unless it's the last FILESTREAM data filegroup left.

5525

16

No

The READ_ONLY, READ_WRITE, and ONLINE/OFFLINE properties cannot be modified on a FILESTREAM log filegroup.

5526

16

No

The FILESTREAM log file '%.*ls' cannot be removed because it is being referenced by a FILESTREAM data filegroup.

5527

16

No

The primary FILESTREAM log file cannot be dropped because other FILESTREAM filegroups exist.

5528

16

No

A database can have at most one primary FILESTREAM log filegroup and log file.

5531

16

No

Error 0x%x (NT status code) was encountered when SQL Server attempts to change the logging mode of Transaction File System Resource Manager located at '%.*ls' from '%.*ls' to '%.*ls'.

5532

16

No

SQL Server cannot obtain the Kernel Transaction Manager's transaction context to perform file system operation.

5533

23

No

The FILESTREAM file system log record that has the LSN '%d:%d:%d' is missing. Log folder '%.*ls' is corrupted. Restore the database from a backup.

5534

23

No

SQL log record at LSN '%d:%d:%d' for database '%.*ls' is corrupted. Database cannot recover.

5535

23

No

FILESTREAM data container '%.*ls' is corrupted. Database cannot recover.

5536

23

No

FILESTREAM deleted folder '%.*ls' is corrupted. Database cannot recover.

5537

16

No

Function %ls is only valid on columns with the FILESTREAM attribute.

5538

16

No

Partial updates are not supported on columns that have a FILESTREAM as a source.

5539

16

No

The ROWGUIDCOL column associated with the FILESTREAM being used is not visible where method %ls is called.

5540

16

No

The FILESTREAM column cannot be used with method %ls because the associated ROWGUIDCOL of the base table is nullable or does not have a unique constraint.

5541

16

No

An open mode must be used when a FILESTREAM column is opened as a file.

5542

16

No

The FILESTREAM filegroup '%.*ls' has no files assigned to it. FILESTREAM data cannot be populated on this filegroup until a file is added.

5552

16

No

FILESTREAM file named with GUID '%.*ls' that belongs to FILESTREAM data file ID 0x%x does not exist or cannot be opened.

5553

16

No

SQL Server internal error. FILESTREAM manager cannot continue with current command.

5554

16

No

The total number of versions for a single file has reached the maximum limit set by the file system.

5555

16

No

The operation has failed because the FILESTREAM data cannot be renamed.

5570

16

No

FILESTREAM Failed to find the garbage collection table.

5571

23

No

Internal FILESTREAM error: failed to access the garbage collection table.

5572

23

No

Internal FILESTREAM error: failed to perform a filesystem operation because of a potential corruption.

5573

10

No

Internal FILESTREAM error: failed to access the tombstones table with HRESULT: 0x%x.

5574

16

No

A database cannot be enabled for both FILESTREAM storage and Database Mirroring.

5575

10

No

Operation '%ls' failed with HRESULT: %ls in file '%hs', line %d while executing sp_filestream_configure.

5578

16

No

A failure occurred while FILESTREAM configuration was being changed or applied. For more information, see the SQL Server error log.

5579

10

No

FILESTREAM: effective level = %d, configured level = %d, file system access share name = '%.*ls'.

5580

16

No

FILESTREAM InstanceGuid is null. Registry settings might be corrupted.

5581

10

No

FILESTREAM feature has been disabled. Restart the instance of SQL Server for the settings to fully take effect. If you have data in FILESTREAM columns, it will not be accessible after the SQL Server instance has been restarted.

5582

10

No

Machine reboot is required before the FILESTREAM feature settings can take effect.

5583

16

No

The specified value for the enable_level parameter of the sp_filestream_configure stored procedure is not valid. The value must be 0, 1, 2, or 3.

5584

16

No

Another session is executing the sp_filestream_configure stored procedure. Check the updated configuration settings and retry the operation if necessary.

5586

10

No

The FILESTREAM feature is already configured to the specified level. No change has been made.

5588

16

No

Access to FILESTREAM data is not supported under snapshot isolation level.

5589

16

No

Access to FILESTREAM data is not supported under row versioning-based read committed snapshot isolation (RCSI).

5590

16

No

FILESTREAM operations are not supported on the platform.

5591

16

No

FILESTREAM feature is disabled.

5592

16

No

FILESTREAM feature doesn't have file system access enabled.

5593

16

No

FILESTREAM feature is not supported on WoW64. The feature is disabled.

5594

16

No

The value specified for the computer_name_format parameter to the .PathName() function is not valid.

5595

16

No

.PhysicalPathName is disabled.

5596

10

No

FILESTREAM feature configuration might be inconsistent. Use the sp_filestream_configure stored procedure to reset the configuration.

5597

16

No

FILESTREAM feature could not be initialized. The Windows Administrator must enable FILESTREAM on the instance using Configuration Manager before enabling through sp_configure.

5598

16

No

FILESTREAM feature is not supported on user instances.

5600

16

No

The Cross Database Chaining option cannot be set to the specified value on the specified database.

5601

16

No

The service master key could not be force regenerated as requested by the -F startup option. The error number is %ld.

5602

16

No

The service master key regeneration was successful.

5603

16

No

The password for SA could not be force regenerated as requested by the -K startup option. The error number is %ld.

5604

16

No

The password regeneration attempt for SA was successful.

5701

10

No

Changed database context to '%.*ls'.

5702

10

No

SQL Server is terminating this process.

5703

10

No

Changed language setting to %.*ls.

5803

10

No

Unknown configuration (id = %d) encountered in sys.configurations.

5804

16

Yes

Character set, sort order, or collation cannot be changed at the server level because at least one database is not writable. Make the database writable, and retry the operation.

5805

16

No

Too few locks specified. Minimum %d.

5807

16

No

Recovery intervals above %d minutes not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.

5808

16

No

Ad hoc update to system catalogs is not supported.

5810

16

No

Valid values for the fill factor are 0 to 100.

5812

14

No

You do not have permission to run the RECONFIGURE statement.

5828

16

No

User connections are limited to %d.

5829

16

No

The specified user options value is invalid.

5831

16

No

Minimum server memory value (%d) must be less than or equal to the maximum value (%d).

5832

16

No

The affinity mask specified does not match the CPU mask on this system.

5833

16

No

The affinity mask specified is greater than the number of CPUs supported or licensed on this edition of SQL Server.

5834

16

No

The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration.

5835

16

No

Failed to start CPUs with the mask 0x%lx on the system.

5836

16

No

Lightweight pooling is not supported on this platform or in this edition of SQL Server.

5837

16

No

The service broker listen port cannot be dynamic. Valid port values are 1024-32767.

5838

16

No

The service broker connection authentication value is invalid.

5839

16

No

The service broker message forward store size cannot be set to 0.

5840

16

No

The service broker message forward mode is invalid.

5841

16

No

The default full-text language is not supported by the full-text search component.

5842

16

No

Too few worker threads are specified. The minimum is %d.

5843

16

No

Address Windowing Extensions (AWE) is not supported in this edition of SQL Server.

5844

16

No

User Instances are not supported in this edition of SQL Server.

5845

16

No

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.

5846

16

No

Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling".

5848

10

Yes

Physical CPU id %u has been hot added to node id %u as logical CPU id %u. This is an informational message only. No user action is required.

5849

10

Yes

Online CPU addition is not supported in the current edition of SQL Server.

5850

10

Yes

Online addition of CPU resources cannot be completed. A software non-uniform memory access (soft-NUMA) configuration was specified at SQL Server startup that does not allow online addition of CPU resources. To use the additional CPU resources, either add the new CPUs to the soft-NUMA configuration and restart SQL Server, or remove the soft-NUMA configuration and restart SQL Server.

5851

10

No

The AccessCheckResult quota must be greater than or equal to the bucket count

5852

10

No

The AccessCheckResult bucket count must be less than %d.

5854

10

No

The AccessCheckResult bucket count must be less than %d.

5904

17

Yes

Unable to issue checkpoint: there are not enough locks available. Background checkpoint process will remain suspended until locks are available. To free up locks, list transactions and their locks, and terminate transactions with the highest number of locks.