SQL Server Errors

Cannot bulk load. The file “%ls” does not exist.

Error Message: Msg 4860, Level 16, State 1, Line 6 Cannot bulk load. The file “%ls” does not exist. Severity level: 16. Description: This error message appears when you try to bulk load data from a non-existing file. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the […]

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 […]

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch.

Error Message: Msg 10507, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch. Modify the values to match a statement in the module or batch. Severity level: 16. Description: […]

COMPUTE clause #%d, aggregate expression #%d is not in the select list.

Error Message: Msg 411, Level 16, State 1, Line 6 COMPUTE clause #%d, aggregate expression #%d is not in the select list. Severity level: 16. Description: This error message appears when you try to use an aggregate expression in a COMPUTE clause that does not appear in the SELECT list. Consequences: The T-SQL statement can […]

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 […]

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 |