SQL Server FAQs


Categories : Performance Tuning | DBA | Developer | Errors

A trigger returned a resultset and the server option ‘disallow results from triggers’ is true.

Index ‘%.*ls’ could not be created or rebuilt. The key length for this index (%d bytes) exceeds the maximum allowed length of ‘%d’ bytes when using the vardecimal storage format.

Cannot set NOCOUNT to OFF inside the trigger execution because the server option “disallow_results_from_triggers” is true or we are inside LOGON trigger execution.

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ and source table ‘%.*ls’ have different vardecimal storage format values.

Explicit value must be specified for identity column in table ‘%.*ls’ either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.

Derived table ‘%.*ls’ is not updatable because it contains aggregates, or a DISTINCT or GROUP BY clause, or PIVOT or UNPIVOT operator.

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.