SQL Server Errors

The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.

Error Message: The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB. The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB. Severity level: 10. Description: This informational error message appears when you try to run DBCC CHECKCATALOG on tempdb. Consequences: Resolution: Error of this severity level are informational errors that […]

FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table.

Error Message: Msg 1716, Level 16, State 1, Line 1 FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table. Severity level: 16. Description: This error message appears when you try to use the FILESTREAM_ON keyword in a CREATE […]

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

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

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a column level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint.

Error Message: Msg 4971, Level 16, State 1, Line 2 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a column level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint. Severity level: 16. Description: This error message appears when you try to execute an ALTER TABLE SWITCH command, for […]
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 |