SQL Server FAQs

Categories : Performance Tuning | DBA | Developer | Errors

Cannot create the clustered index “%.ls” on view “%.ls” because the index key includes columns that are not in the GROUP BY clause. Consider eliminating columns that are not in the GROUP BY clause from the index key.

Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns.

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

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.

Page 14 of 82
<
1
...
9
10
11
12
13
14
15
16
17
18
...
82
>

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 |