Tag: SQL Server Errors

SQL Server Error Msg 21548 – Cannot execute sp_change_subscription_properties. This stored procedure can only be used for publications that have at least one pull subscription.

SQL Server Error Msg 1908 – Column ‘%.*ls’ is partitioning column of the index ‘%.*ls’. Partition columns for a unique index must be a subset of the index key.

SQL Server Error Msg 10088 – The order of the columns was not specified in the object that created the rowset. The provider had to reexecute the command to reposition the next fetch position to its initial position, and the order of the columns changed.

SQL Server Error Msg 22844 – The ‘%s’ option must be either 1 or 0.

SQL Server Error Msg 23101 – Access is denied.

SQL Server Error Msg 35476 – transactions that access memory optimized tables or natively compiled modules

SQL Server Error Msg 11522 – The metadata could not be determined because statement ‘%.*ls’ in procedure ‘%.*ls’ uses an undeclared parameter in a context that affects its metadata.

SQL Server Error Msg 22548 – Vertical partitioning is only allowed for log-based articles.

SQL Server Error Msg 1489 – Database Mirroring is disabled on this server due to error %d.  Check the errorlog and configuration for more information.

SQL Server Error Msg 28961 – Error: invalid configuration file, no bricks defined.

SQL Server Error Msg 7916 – Repair: Deleted record for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), on page %S_PGID,  slot %d. Indexes will be rebuilt.

SQL Server Error Msg 20023 – Invalid @subscriber_type value. Valid options are ‘local’, ‘global’, or ‘anonymous’.

SQL Server Error Msg 20718 – Log settings do not exist for subscriber server ‘%s’, subscriber db ‘%s’, webserver ‘%s’. Use sp_addmergelogsettings to add the settings.

SQL Server Error Msg 40132 – Before dropping a table group, you have to delete all the partitions.

SQL Server Error Msg 41197 – The FAILOVER_MODE option has not been specified for the replica ‘%.*ls’. Reenter the command, specifying a failover mode for the replica.

SQL Server Error Msg 33411 – The option ‘%.*ls’ is only valid when used on a FileTable. Remove the option from the statement.

SQL Server Error Msg 3273 – The ambiguity for master has be detected. please specify PHYSMASTER or replicatedmaster database explicitly in action ‘%ls’.

SQL Server Error Msg 8156 – The column ‘%.*ls’ was specified multiple times for ‘%.*ls’.

SQL Server Error Msg 13622 – An invalid value was specified for argument %d.

SQL Server Error Msg 10506 – Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement.