SQL Server FAQs

Categories : Performance Tuning | DBA | Developer | Errors

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

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.

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

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

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.

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

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

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

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

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.

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 |