SSPAdmin



As well as running SQLServerPerformance.com I also operate Core Earnings and Derivatives ONE. I blog at Jude O'Kelly

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, matches the existing plan guide ‘%.*ls’ in the database - 01 Aug 2009

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

Cannot create %S_MSG on view ‘%.*ls’ because it contains one or more UNION, INTERSECT, or EXCEPT operators. Consider creating a separate indexed view for each query that is an input to the UNION, INTERSECT, or EXCEPT operators of the original view. - 01 Aug 2009

Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint. - 01 Aug 2009

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

The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed (%d). - 14 Jul 2009

Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column is non-deterministic. - 14 Jul 2009

Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has a DEFAULT constraint. - 14 Jul 2009

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

Partitioned view ‘%.*ls’ is not updatable because it does not deliver all columns from its member tables. - 14 Jul 2009

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 |