SQL Server Errors or Failures Error: 1855 to Error: 1921



Error: 1855, Severity: 16,
System table sysfiles1 is corrupted.

Error: 1856, Severity: 16,
Cannot attach file ‘%.*ls’ as database ‘%.*ls’ because this database name is already attached with file ‘%.*ls’

Error: 1857, Severity: 16,
Cannot attach file ‘%.*ls’ as database ‘%.*ls’ because this file is already in use for database ‘%.*ls’

Error: 1858, Severity: 16,
Could not create snapshot database because user database is still in recovery.

Error: 1901, Severity: 16,
Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because key column ‘%.*ls’ is imprecise, computed and not persisted. Consider removing reference to column in view index or statistics key or changing column to be precise. If column is computed in

Error: 1902, Severity: 16,
Cannot create more than one clustered index on %S_MSG ‘%.*ls’. Drop the existing clustered index ‘%.*ls’ before creating another.

Error: 1904, Severity: 16,
The %S_MSG ‘%.*ls’ on table ‘%.*ls’ has %d columns in the key list. The maximum limit for %S_MSG key column list is %d.

Error: 1907, Severity: 16,
Cannot recreate index ‘%.*ls’. The new index definition does not match the constraint being enforced by the existing index.

Error: 1908, Severity: 16,
Column ‘%.*ls’ is partitioning column of the index ‘%.*ls’. Partition columns for a unique index must be a subset of the index key.

Error: 1909, Severity: 16,
Cannot use duplicate column names in %S_MSG. Column name ‘%.*ls’ listed more than once.

Error: 1910, Severity: 16,
Could not create %S_MSG ‘%.*ls’ because it exceeds the maximum of %d allowed per table or view.

Error: 1911, Severity: 16,
Column name ‘%.*ls’ does not exist in the target table or view.

Error: 1912, Severity: 16,
Could not proceed with index DDL operation on %S_MSG ‘%.*ls’ because it conflicts with another concurrent operation that is already in progress on the object. The concurrent operation could be an online index operation on the same object or another concur

Error: 1913, Severity: 16,
The operation failed because an index or statistics with name ‘%.*ls’ already exists on %S_MSG ‘%.*ls’.

Error: 1914, Severity: 16,
Index cannot be created on object ‘%.*ls’ because the object is not a user table or view.

Error: 1915, Severity: 16,
Cannot alter a non-unique index with ignore_dup_key index option. Index ‘%.*ls’ is non-unique.

Error: 1916, Severity: 16,
CREATE INDEX options %ls and %ls are mutually exclusive.

Error: 1917, Severity: 16,
Cannot create, rebuild or drop an index on a local temporary table online. Perform the index operation offline.

Error: 1919, Severity: 16,
Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as a key column in an index.

Error: 1921, Severity: 16,
Invalid %S_MSG ‘%.*ls’ specified.

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.

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 *