Tag: SQL Server Errors

SQL Server Error Msg The table-valued parameter “%.*ls” cannot be declared as an OUTPUT parameter. – 16

SQL Server Error Msg 7622 – There is not sufficient disk space to complete this operation for the full-text catalog “%ls”.

SQL Server Error Msg 40005 – Duplicated transaction id.

SQL Server Error Msg 45403 – The operation could not be completed because a service tier change is in progress for managed instance ‘%.*ls.’ Please wait for the operation in progress to complete and try again.

SQL Server Error Msg 29251 – Configuration manager cannot create notification.

SQL Server Error Msg 10901 – User does not have permission to alter the resource governor configuration.

SQL Server Error Msg 1488 – Database “%.*ls” database is in single user mode which is incompatible with participating in database mirroring or in an availability group. Set database to multi-user mode, and retry the operation.

SQL Server Error Msg 41413 – Some availability replicas are disconnected.

SQL Server Error Msg 4710 – Could not truncate object ‘%.*ls’ because it or one of its indexes resides on an offline filegroup ‘%.*ls’.

SQL Server Error Msg 2801 – The definition of object ‘%.*ls’ has changed since it was compiled.

SQL Server Error Msg 45331 – The operation could not be completed because the read scale value specified is not supported for a ‘%ls’ database.

SQL Server Error Msg 41913 – Multiple filestream files are not supported in SQL Database Managed Instance.

SQL Server Error Msg 3103 – A partial restore sequence cannot be initiated by this command. To initiate a partial restore sequence, use the WITH PARTIAL clause of the RESTORE statement and provide a backup set which includes a full copy of at least the primary data file. The WITH PARTIAL clause of the RESTORE statement may not be used for any other purpose.

SQL Server Error Msg 35317 – The statement failed because specifying %S_MSG is not allowed when creating a columnstore index. Consider creating a columnstore index without specifying %S_MSG.

SQL Server Error Msg 3041 – BACKUP failed to complete the command %.*ls. Check the backup application log for detailed messages.

SQL Server Error Msg 40672 – The service objective assignment for a database cannot be changed more than once per %d hour(s). Please retry the operation %d hour(s) after the last service objective assignment completed for this database.

SQL Server Error Msg 21168 – Only members of the sysadmin fixed server role, members of the db_owner fixed database role, and owners of subscriptions served by the specified replication agent job can modify the agent offload settings.

SQL Server Error Msg 29233 – Configuration manager thread encountered fatal exception (error: %d state: %d severity: %d). This is a serious error and brick will be taken down. Examine previously logged messages to figure out the cause for this fatal failure.

SQL Server Error Msg 821 – Could not unhash buffer at 0x%p with a buffer page number of %S_PGID and database ID %d with HASHED status set. The buffer was not found. %S_PAGE. Contact Technical Support.

SQL Server Error Msg 20593 – Cannot modify publication ‘%s’.  The sync_method cannot be changed to ‘native’, or ‘concurrent’ because the publication is enabled for heterogeneous subscribers.