SQL Server FAQs


Categories : Performance Tuning | DBA | Developer | Errors

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.

Backup and restore operations are not allowed on database tempdb.

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

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

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

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.

Cannot create plan guide ‘%.*ls’ because the module ‘%.*ls’ does not exist or you do not have needed permission.

ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same collation in tables ‘%.*ls’ and ‘%.*ls’.

Cannot create plan guide ‘%.*ls’ because @module_or_batch can not be compiled.

Cannot create plan guide ‘%.*ls’ because value ‘%.*ls’ provided for @module_or_batch is not legal two-part name. Use ‘schema_name.object_name’.


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 |