SQL Server Errors

FIPS Warning: The length of identifier ‘%.*ls’ exceeds 18.

Error Message: FIPS Warning: The length of identifier ‘%.*ls’ exceeds 18. FIPS Warning: The length of identifier ‘%.*ls’ exceeds 18. Severity level: 10. Description: This informational error message appears when you try to use an identifier that exceeds the length of 18 characters. Consequences: Resolution: Error of this severity level are informational errors that do […]

Cannot create %S_MSG on view “%.*ls” because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.

Error Message: Msg 10119, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view. Severity level: 16. Description: This error message appears when you try to create an index on a view that contains a CUBE, ROLLUP, or […]

Cannot ‘%ls’ plan guide ‘%.*ls’ because it does not exist or you do not have permission. Verify plan guide name and database of current session, and that you have needed permission.

Error Message: Msg 10508, Level 16, State 1, Procedure sp_control_plan_guide_int, Line 1 Cannot ‘%ls’ plan guide ‘%.*ls’ because it does not exist or you do not have permission. Verify plan guide name and database of current session, and that you have needed permission. Severity level: 16. Description: This error message appears when you try to […]

Backup and restore operations are not allowed on database tempdb.

Error Message: Msg 3147, Level 16, State 3, Line 1 Backup and restore operations are not allowed on database tempdb. Severity level: 16. Description: This error message appears when you try to backup or restore the tempdb database. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the […]

Cannot create %S_MSG on view “%.*ls” because it contains the TOP keyword. Consider removing TOP or not indexing the view.

Error Message: Msg 10101, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it contains the TOP keyword. Consider removing TOP or not indexing the view. Severity level: 16. Description: This error message appears when you try to create an index on a view that contains the TOP keyword. Consequences: The […]

Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,...n ] )’.

Error Message: Msg 10504, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( <query_hint> [ ,...n ] )’. Severity level: 16. Description: This error message appears when you try to create a planguide, but the @hints parameter is incorrect. Consequences: The T-SQL statement can be […]

Cannot create plan guide ‘%.*ls’ because object ‘@module_or_batch’ is encrypted. Consider tuning query using other techniques such as indexes and statistics.

Error Message: Msg 10512, Level 16, State 1, Procedure, Line 2 Cannot create plan guide ‘%.*ls’ because object ‘@module_or_batch’ is encrypted. Consider tuning query using other techniques such as indexes and statistics. Severity level: 16. Description: This error message appears when you try to create a planguide, but the object specified in the @module_or_batch parameter […]

Derived table ‘%.*ls’ is not updatable because a column of the derived table is derived or constant.

Error Message: Msg 4421, Level 16, State 1, Line 1 Derived table ‘%.*ls’ is not updatable because a column of the derived table is derived or constant. Severity level: 16. Description: This error message appears when you try to update a column of a derived table that is either derived or constant. Consequences: The T-SQL […]

Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls” with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns.

Error Message: Msg 10126, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls” with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns. Severity level: 16. Description: This error message […]

Cannot INSERT into partitioned view ‘%.*ls’ because table ‘%.*ls’ has an IDENTITY constraint.

Error Message: Msg 4433, Level 16, State 4, Line 2 Cannot INSERT into partitioned view ‘%.*ls’ because table ‘%.*ls’ has an IDENTITY constraint. Severity level: 16. Description: This error message appears when you try to insert into a partitioned view, but at least one of its member tables has an IDENTITY constraint. Consequences: The T-SQL […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |