SQL Server Errors or Failures Error: 2545 to Error: 2566

SQLServerF1

 

Error: 2545, Severity: 10, ROWS count: changed from (%I64d) to (%I64d) rows.,
Error: 2546, Severity: 10, Index ‘%.*ls’ on table ‘%.*ls’ is marked as disabled. Rebuild the index to bring it online.,
Error: 2547, Severity: 16, Unable to process object ID %ld (object “%.*ls”) because it is a synonym. If the object referenced by the synonym is a table or view, retry the operation using the base object that the synonym references.,
Error: 2548, Severity: 10, DBCC: Compaction phase of index ‘%.*ls’ is %d%% complete.,
Error: 2549, Severity: 10, DBCC: Defrag phase of index ‘%.*ls’ is %d%% complete.,

Error: 2550, Severity: 16, The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because it is being reorganized by another process.,
Error: 2551, Severity: 16, The indexes on table “%.*ls” cannot be reorganized because there is already an online index build or rebuild in progress on the table.,
Error: 2552, Severity: 16, The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because page level locking is disabled.,
Error: 2553, Severity: 10, Table ‘%.*ls’ will not be available during reorganizing index ‘%.*ls’. This is because the index reorganization operation performs inside a user transaction and the entire table is exclusively locked.,
Error: 2554, Severity: 16, The index “%.*ls” (partition %ld) on table “%.*ls” cannot be reorganized because the filegroup is read-only.,

Error: 2555, Severity: 16, Cannot move all contents of file “%.*ls” to other places to complete the emptyfile operation.,
Error: 2556, Severity: 16, There is insufficient space in the filegroup to complete the emptyfile operation.,
Error: 2557, Severity: 14, User ‘%.*ls’ does not have permission to run DBCC %ls for object ‘%.*ls’.,
Error: 2558, Severity: 16, %I64d incorrect counts were detected in database ‘%.*ls’.,
Error: 2559, Severity: 16, The ‘%ls’ and ‘%ls’ options are not allowed on the same statement.,
Error: 2560, Severity: 16, Parameter %d is incorrect for this DBCC statement.,
Error: 2561, Severity: 16, Parameter %d is incorrect for this statement.,
Error: 2562, Severity: 16, Checking FILESTREAM filegroup “%.*ls” (ID %d) is not supported in DBCC CHECKFILEGROUP. Specify a filegroup containing user objects with FILESTREAM data instead.,
Error: 2563, Severity: 16, DBCC SHRINKFILE for FILESTREAM containers requires EMPTYFILE option and does not allow any other options.,
Error: 2566, Severity: 14, DBCC DBREINDEX cannot be used on system tables.,

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *