SQL Server Errors

CREATE DATABASE permission can only be granted in the master database.

Error Message: CREATE DATABASE permission can only be granted in the master database. CREATE DATABASE permission can only be granted in the master database. Severity level: 16. Description: This error message appears when you try to grant CREATE DATABASE permission while not being in the master database context. Consequences: The T-SQL statement can be parsed, […]

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

Cannot create %S_MSG on view “%.*ls” because it references derived table “%.*ls” (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.

Error Message: Msg 10109, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it references derived table “%.*ls” (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view. Severity level: 16. Description: This error message appears when you try to create […]

Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,...n ] )’.

Error Message: Msg 10504, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( <query_hint> [ ,...n ] )’. Severity level: 16. Description: This error message appears when you try to create a planguide, but the @hints parameter is incorrect. Consequences: The T-SQL statement can be […]

Cannot specify included columns for a clustered index.

Error Message: Msg 10601, Level 16, State 1, Line 1 Cannot specify included columns for a clustered index. Severity level: 16. Description: This error message appears when you try to use the INCLUDE clause for a clustered index. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the […]

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

Error Message: Msg 10112, Level 16, State 1, Line 2 Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint. Severity level: 16. Description: This error message appears when you try to create an index on a view that contains a JOIN hint. […]
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 |