Tag: MS SQL Server Error Codes
SQL Server Error Code – 157 an aggregate may not appear in the set l
In this blog post, you’ll learn more about the SQL Server Error Code 157 and the error message description that is shown SQL Server Error Code 157 SQL Server Error Description for the Code :157 An aggregate may not appear in the set list of an UPDATE statement.
SQL Server Error Code – 3115 the database is using the simple recover
In this blog post, you’ll learn more about the SQL Server Error Code 3115 and the error message description that is shown SQL Server Error Code 3115 SQL Server Error Description for the Code :3115 The database is using the simple recovery model. It is not possible to restore a subset of the read-write data.
SQL Server Error Code – 5329 windowed functions are not allowed in th
In this blog post, you’ll learn more about the SQL Server Error Code 5329 and the error message description that is shown SQL Server Error Code 5329 SQL Server Error Description for the Code :5329 Windowed functions are not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
SQL Server Error Code – 8971 forwarded row mismatch: object id %d, pa
In this blog post, you’ll learn more about the SQL Server Error Code 8971 and the error message description that is shown SQL Server Error Code 8971 SQL Server Error Description for the Code :8971 Forwarded row mismatch: Object ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) page %S_PGID, slot %d points to forwarded row page %S_PGID, slot %d; the forwarded row…
SQL Server Error Code – 10762 the %.*ls function is not allowed in the
In this blog post, you’ll learn more about the SQL Server Error Code 10762 and the error message description that is shown SQL Server Error Code 10762 SQL Server Error Description for the Code :10762 The %.*ls function is not allowed in the current compatibility mode. It is only allowed in 110 mode or higher.
SQL Server Error Code – 14038 could not disable database for publishin
In this blog post, you’ll learn more about the SQL Server Error Code 14038 and the error message description that is shown SQL Server Error Code 14038 SQL Server Error Description for the Code :14038 Could not disable database for publishing.
SQL Server Error Code – 20812 the specified source object must be a sy
In this blog post, you’ll learn more about the SQL Server Error Code 20812 and the error message description that is shown SQL Server Error Code 20812 SQL Server Error Description for the Code :20812 The specified source object must be a synonym if it is published as a ‘synonym schema only’ type article.
SQL Server Error Code – 33003 ddl statement is not allowed.
In this blog post, you’ll learn more about the SQL Server Error Code 33003 and the error message description that is shown SQL Server Error Code 33003 SQL Server Error Description for the Code :33003 DDL statement is not allowed.
SQL Server Error Code – 33113 database encryption scan for database ‘%
In this blog post, you’ll learn more about the SQL Server Error Code 33113 and the error message description that is shown SQL Server Error Code 33113 SQL Server Error Description for the Code :33113 Database encryption scan for database ‘%.*ls’ is complete.
SQL Server Error Code – 40031 the partition key column for table ‘%.*l
In this blog post, you’ll learn more about the SQL Server Error Code 40031 and the error message description that is shown SQL Server Error Code 40031 SQL Server Error Description for the Code :40031 The partition key column for table ‘%.*ls.%.*ls’ is undefined.
SQL Server Error Code – 14856 the procedure %ls requires the %ls param
In this blog post, you’ll learn more about the SQL Server Error Code 14856 and the error message description that is shown SQL Server Error Code 14856 SQL Server Error Description for the Code :14856 The procedure %ls requires the %ls parameter if the database is not enabled for REMOTE_DATA_ARCHIVE.
SQL Server Error Code – 21388 the concurrent snapshot for publication
In this blog post, you’ll learn more about the SQL Server Error Code 21388 and the error message description that is shown SQL Server Error Code 21388 SQL Server Error Description for the Code :21388 The concurrent snapshot for publication ‘%s’ is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of…
SQL Server Error Code – 4348 the online restore to database ‘%ls’ fai
In this blog post, you’ll learn more about the SQL Server Error Code 4348 and the error message description that is shown SQL Server Error Code 4348 SQL Server Error Description for the Code :4348 The online restore to database ‘%ls’ failed. It may be appropriate to perform an offline restore instead. An offline restore is initiated by using BACKUP LOG WITH NORECOVERY.
SQL Server Error Code – 11402 alter table switch statement failed. tar
In this blog post, you’ll learn more about the SQL Server Error Code 11402 and the error message description that is shown SQL Server Error Code 11402 SQL Server Error Description for the Code :11402 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ is referenced by %d indexed view(s), but source table ‘%.*ls’ is only referenced by %d indexed view(s). Every indexed view on the…
SQL Server Error Code – 31016 could not cleanup hypothetical indexes a
In this blog post, you’ll learn more about the SQL Server Error Code 31016 and the error message description that is shown SQL Server Error Code 31016 SQL Server Error Description for the Code :31016 Could not cleanup hypothetical indexes and statistics when cancelling DTA tuning for auto indexing.
SQL Server Error Code – 35389 the statement failed because column ‘%.*
In this blog post, you’ll learn more about the SQL Server Error Code 35389 and the error message description that is shown SQL Server Error Code 35389 SQL Server Error Description for the Code :35389 The statement failed because column ‘%.*ls’ on table ‘%.*ls’ is a computed column of a LOB type. Columnstore indexes cannot include computed columns of LOB types.
SQL Server Error Code – 320 the compile-time variable value for ?%.*
In this blog post, you’ll learn more about the SQL Server Error Code 320 and the error message description that is shown SQL Server Error Code 320 SQL Server Error Description for the Code :320 The compile-time variable value for ?%.*ls? in the OPTIMIZE FOR clause must be a literal.
SQL Server Error Code – 1985 cannot create %s_msg on view ?%.*ls?. it
In this blog post, you’ll learn more about the SQL Server Error Code 1985 and the error message description that is shown SQL Server Error Code 1985 SQL Server Error Description for the Code :1985 Cannot create %S_MSG on view ?%.*ls?. It contains one or more XML data type methods.
SQL Server Error Code – 5244 repair statement not processed. one or
In this blog post, you’ll learn more about the SQL Server Error Code 5244 and the error message description that is shown SQL Server Error Code 5244 SQL Server Error Description for the Code :5244 Repair statement not processed. One or more files in the database are read-only and must be made writeable in order to run repair.
SQL Server Error Code – 10340 drop assembly failed. error code: 0x%x.
In this blog post, you’ll learn more about the SQL Server Error Code 10340 and the error message description that is shown SQL Server Error Code 10340 SQL Server Error Description for the Code :10340 DROP ASSEMBLY failed. Error code: 0x%x.