SQL Server Errors or Failures Error: 1949 to Error: 1976

SQLServerF1

 

Error: 1949, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’. The function ‘%s’ yields nondeterministic results. Use a deterministic system function, or modify the user-defined function to return deterministic results.

Error: 1956, Severity: 16,
Cannot create %S_MSG on the ‘%.*ls’ view because it uses the nondeterministic user-defined function ‘%.*ls’. Remove the reference to the function, or make it deterministic.

Error: 1957, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’ because view uses imprecise user-defined function ‘%.*ls’. Consider removing reference to function or altering it to be precise.

Error: 1959, Severity: 16,
Cannot create an index on a view or computed column because the compatibility level of this database is less than 80. Use sp_dbcmptlevel to raise the compatibility level of the database.

Error: 1961, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’. The collation cast expression with collation name ‘%.*ls’ is non-deterministic because it is dependent on the operating system.

Error: 1962, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’ because column ‘%.*ls’ that is referenced by the view in the WHERE or GROUP BY clause is imprecise. Consider eliminating the column from the view, or altering the column to be precise.

Error: 1963, Severity: 16,
Cannot create %S_MSG on view “%.*ls”. The view contains a convert that is imprecise or non-deterministic.

Error: 1964, Severity: 16,
Cannot create %S_MSG on view “%.*ls”. The view contains an imprecise constant.

Error: 1965, Severity: 16,
Cannot create %S_MSG on view “%.*ls”. The view contains an imprecise arithmetic operator.

Error: 1966, Severity: 16,
Cannot create %S_MSG on view ‘%.*ls’. The view contains an imprecise aggregate operator.

Error: 1967, Severity: 16,
Cannot create a new clustered index on a view online.

Error: 1968, Severity: 16,
Cannot convert a nonclustered index to a clustered index online using DROP_EXISTING option.

Error: 1969, Severity: 16,
Default FILESTREAM filegroup is not available in database ‘%.*ls’.

Error: 1970, Severity: 10,
Warning: Online index operation on table ‘%.*ls’ will proceed but concurrent access to the table may be limited due to residual lock on the table from a previous operation in the same transaction.

Error: 1971, Severity: 16,
Cannot disable index ‘%.*ls’ on table ‘%.*ls’. Permission denied to disable foreign key ‘%.*ls’ on table ‘%.*ls’ that uses this index.

Error: 1972, Severity: 16,
Cannot disable clustered index ‘%.*ls’ on table ‘%.*ls’. Permission denied to alter the referencing view ‘%.*ls’ while disabling its clustered index.

Error: 1973, Severity: 16,
Cannot perform the specified operation on disabled index ‘%.*ls’ on %S_MSG ‘%.*ls’.

Error: 1974, Severity: 16,
Cannot perform the specified operation on %S_MSG ‘%.*ls’ because its clustered index ‘%.*ls’ is disabled.

Error: 1975, Severity: 16,
Index ‘%.*ls’ row length exceeds the maximum permissible length of ‘%d’ bytes.

Error: 1976, Severity: 16,
Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because cannot verify key column ‘%.*ls’ is precise and deterministic. Consider removing column from index or statistics key, marking column persisted in base table if it is computed, or using non-

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 *