SQL Server

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.

SQL Server Error Msg 10766 – CENTRAL_AGG must be specified after all columns in the GROUP BY clause. Modify the query and re-run it.

SQL Server Error Msg 33077 – RESERVE_DISK_SPACE cannot be specified when setting MAXSIZE = UNLIMITED. Either reduce MAXSIZE or do not specify RESERVE_DISK_SPACE.

SQL Server Error Msg 6814 – In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS require attribute names in ‘%.*ls’.

SQL Server Error Msg 45006 – The federation key value is out of bounds for this member.

SQL Server Error Msg 35343 – The statement failed. Column ‘%.*ls’ has a data type that cannot participate in a columnstore index.

SQL Server Error Msg 4502 – View or function ‘%.*ls’ has more column names specified than columns defined.

SQL Server Error Msg 2502 – Memory object list dump failed due to temporary inconsistency in the memory object structure. Please try again.

SQL Server Error Msg 35456 – it is involved in a mirroring pair. Consider disabling mirroring, changing the setting, then re-establishing mirroring