Tag: SQL Server Errors

SQL Server Error Msg Only natively compiled modules can be used with %S_MSG. – 16

SQL Server Error Msg 33103 – A database encryption key already exists for this database.

SQL Server Error Msg 1522 – Sort operation failed during an index build. The overwriting of the allocation page in database ‘%.*ls’ was prevented by terminating the sort. Run DBCC CHECKDB to check for allocation and consistency errors. It may be necessary restore the database from backup.

SQL Server Error Msg 46922 – PolyBase provisioning script performing on master database failed. This is a serious error which might prevent the SQL Server instance from starting. Examine the errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the steps run to completion.

SQL Server Error Msg 27224 – The parameter value cannot be changed after the execution has been started.

SQL Server Error Msg 14063 – The remote server does not exist or has not been designated as a valid Subscriber.

SQL Server Error Msg 22550 – Cannot drop identity column “%s” from the vertical partition when identityrangemanagementoption is set to auto.

SQL Server Error Msg 4102 – The READPAST lock hint is only allowed on target tables of UPDATE and DELETE and on tables specified in an explicit FROM clause.

SQL Server Error Msg 21128 – Terminating immediate updating or queued updating INSERT trigger because it is not the first trigger to fire. Use sp_settriggerorder procedure to set the firing order for trigger ‘%s’ to first.

SQL Server Error Msg 14692 – Insufficient priveleges to start collection set: ‘%s’. Only a member of the ‘sysadmin’ fixed server role can start a collection set without a SQL Server Agent proxy. Attach a SQL Server Agent proxy to the collection set before retrying.

SQL Server Error Msg The compile-time variable value for ‘%.*ls’ in the OPTIMIZE FOR clause must be a literal. – 15

SQL Server Error Msg Replication, Change Data Capture and Change Tracking are not supported in contained databases. The option cannot be enabled on the contained database ‘%s’. – 16

SQL Server Error Msg 43031 – The storage size of %d MB is lower than the primary server’s storage size.

SQL Server Error Msg 14256 – Cannot start the job “%s” (ID %s) because it does not have any job server or servers defined. Associate the job with a job server by calling sp_add_jobserver.

SQL Server Error Msg 1857 – Cannot attach file ‘%.*ls’ as database ‘%.*ls’ because this file is already in use for database ‘%.*ls’

SQL Server Error Msg 41023 – The Windows Server Failover Clustering (WSFC) change handle is invalid because a WSFC notification port has not been created or has been closed.  Create a new WSFC notification port and retry the operation.

SQL Server Error Msg 21084 – Publication ‘%s’ does not allow anonymous subscriptions.

SQL Server Error Msg 40559 – File based statement options are not supported in this version of SQL Server.

SQL Server Error Msg 9206 – The query notification subscription “%ld” cannot be deleted because it does not exist or it has already been fired.

SQL Server Error Msg 33208 – SQL Server Audit failed to access the security log. Make sure that the SQL service account has the required permissions to access the security log.