SQL Server FAQs

Categories : Performance Tuning | DBA | Developer | Errors

Select statements included within a function cannot return data to a client.

Vardecimal storage format is not available in system database ‘%s’.

The last statement included within a function must be a return statement.

Vardecimal storage format cannot be enabled on table ‘%.ls’ because database ‘%.ls’ is a system database. Vardecimal storage format is not available in system databases.

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.

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 |