SQL Server Errors

Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.

Error Message: Msg 257, Level 16, State 3, Line 2 Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query. Severity level: 16. Description: This error message appears when you try to run a query with a implicit conversion from one data type to another, but […]

Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because key column ‘%.*ls’ is imprecise, computed and not persisted. Consider removing reference to column in view index or statistics key or changing column to be precise.

Error Message: Msg 1901, Level 16, State 1, Line 2 Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because key column ‘%.*ls’ is imprecise, computed and not persisted. Consider removing reference to column in view index or statistics key or changing column to be precise. If column is computed in base table consider marking […]

ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.

Error Message: Msg 4920, Level 16, State 0, Line 6 ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist. Severity level: 16. Description: This error message appears when you try to perform an action (enable, disable, etc) for a trigger via an ALTER TABLE statement, but the trigger does not exist. Consequences: […]

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.

Error Message: Msg 266, Level 16, State 2, Procedure, Line 0 Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld. Severity level: 16. Description: This error message appears when you try to execute a procedure, but the transaction count before and after the […]

ALTER TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’.

Error Message: Msg 4921, Level 16, State 0, Line 2 ALTER TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to perform an action (enable, disable, etc) for a trigger via an ALTER TABLE statement, but the trigger does not belong to […]

The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

Error Message: The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. Severity level: 10. Description: This informational error message appears […]

Cannot create %S_MSG on view “%.*ls” because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join instead.

Error Message: Msg 10113, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join instead. Severity level: 16. Description: This error message appears when you try to create an […]

Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement.

Error Message: Msg 10506, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement. Severity level: 16. Description: This error message appears when you try to create a planguide, but the @stmt parameter contains more than one statement. Consequences: The T-SQL statement can be parsed, but […]

FIPS Warning: Line %d has the non-ANSI statement ‘%ls’.

Error Message: FIPS Warning: Line %d has the non-ANSI statement ‘%ls’. FIPS Warning: Line %d has the non-ANSI statement ‘%ls’. Severity level: 10. Description: This informational error message appears when you try to use a non-ANSI compliant statement while the FIPS FLAGGER is activated. Consequences: Resolution: Error of this severity level are informational errors that […]

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.

Error Message: Msg 10116, Level 16, State 1, Line 2 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. Severity level: 16. Description: […]
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 |