SQL Server Errors or Failures Error: 1922 to Error: 1947



Error: 1922, Severity: 16,
Filegroup ‘%.*ls’ has no files assigned to it. Tables, indexes, and large object columns cannot be created on this filegroup. Use ALTER DATABASE to add one or more files to the filegroup.

Error: 1924, Severity: 16,
Filegroup ‘%.*ls’ is read-only.

Error: 1925, Severity: 16,
Cannot convert a clustered index to a nonclustered index by using the DROP_EXISTING option. To change the index type from clustered to nonclustered, delete the clustered index, and then create a nonclustered index by using two separate statements.

Error: 1927, Severity: 16,
There are already statistics on table ‘%.*ls’ named ‘%.*ls’.

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

Error: 1930, Severity: 16,
Cannot convert a nonclustered index to a clustered index because a foreign key constraint references the index. Remove the foreign key constraint and then retry the operation.

Error: 1931, Severity: 16,
The SQL statement cannot be executed because filegroup ‘%.*ls’ is offline. Use the sys.database_files or sys.master_files catalog view to determine the state of the files in this filegroup and then restore the offline file(s) from backup.

Error: 1934, Severity: 16,
%ls failed because the following SET options have incorrect settings: ‘%.*ls’. Verify that SET options are correct for use with %S_MSG.

Error: 1935, Severity: 16,
Cannot create index. Object ‘%.*ls’ was created with the following SET options off: ‘%.*ls’.

Error: 1937, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’ because it references another view ‘%.*ls’. Consider expanding referenced view’s definition by hand in indexed view definition.

Error: 1938, Severity: 16,
Index cannot be created on view ‘%.*ls’ because the underlying object ‘%.*ls’ has a different owner.

Error: 1939, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’ because the view is not schema bound.

Error: 1940, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’. It does not have a unique clustered index.

Error: 1941, Severity: 16,
Cannot create nonunique clustered index on view ‘%.*ls’ because only unique clustered indexes are allowed. Consider creating unique clustered index instead.

Error: 1942, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’. It contains text, ntext, image, FILESTREAM or xml columns.

Error: 1943, Severity: 16,
The index “%.*ls” on table “%.*ls” cannot be reorganized because page level locking is disabled.

Error: 1944, Severity: 16,
Index ‘%.*ls’ was not created because the index key size is at least %d bytes. The index key size cannot exceed 900 bytes. If the index key includes implicit key columns, the index key size cannot exceed 1800 bytes.

Error: 1945, Severity: 10,
Warning! The maximum key length is %d bytes. The index ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.

Error: 1946, Severity: 16,
Operation failed. The index entry of length %d bytes for the index ‘%.*ls’ exceeds the maximum length of %d bytes.

Error: 1947, Severity: 16,
Cannot create %S_MSG on view “%.*ls”. The view contains a self join on “%.*ls”.

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 *