SQL Server FAQs

Categories : Performance Tuning | DBA | Developer | Errors

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.

The logical tables INSERTED and DELETED cannot be updated.

Cannot use table option LARGE VALUE TYPES OUT OF ROW on a user table that does not have any of large value types varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns in it.

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.

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 |