Tag: SQL Server Errors

SQL Server Error Msg 21054 – The trigger at the Subscriber could not execute commands at the Publisher over the linked server connection (triggers are used for Subscribers with updating subscriptions). Ensure sp_link_publication has been used to configure the linked server properly, and ensure that the login used to connect to the Publisher is in the publication access list.

SQL Server Error Msg 21337 – Invalid @subscriber_type value. Valid options are ‘local’ and ‘global’.

SQL Server Error Msg 6856 – FOR XML row XML tag name contains an invalid XML identifier; ‘%c'(0x%04X) is the first character at fault.

SQL Server Error Msg 7711 – The %ls option was specified more than once for the table, or for at least one of its partitions if the table is partitioned.

SQL Server Error Msg 3805 – Warning: Index “%.*ls” on table “%.*ls”.”%.*ls” might be corrupted because it references computed column “%.*ls” containing a non-deterministic conversion from string to date. Run DBCC CHECKTABLE to verify index. Consider using explicit CONVERT with deterministic date style such as 121. Computed column indexes referencing non-deterministic expressions can’t be created in 90 compatibility mode. See Books Online topic “Creating Indexes on Computed Columns” for more information.

SQL Server Error Msg 8444 – The service queue structure is inconsistent.  Possible database corruption.  Run DBCC CHECKDB.

SQL Server Error Msg 40181 – Fabric-database (‘%.*ls’) cannot be paired, the supplied mutex (‘%.*ls’) could not be opened. Error code: %d

SQL Server Error Msg 7949 – – Scan Density [Best Count:Actual Count]…….: %4.2f%ls [%I64d:%I64d]

SQL Server Error Msg 4445 – UNION ALL view ‘%.*ls’ is not updatable because the primary key of table ‘%.*ls’ is not unioned with primary keys of preceding tables.

SQL Server Error Msg 17827 – There was a failure while attempting to encrypt a password. The connection has been closed.%.*ls

SQL Server Error Msg 15215 – Warning: The certificate you created is not yet valid; its start date is in the future.

SQL Server Error Msg 6549 – A .NET Framework error occurred during execution of user defined routine or aggregate ‘%.*ls’: %ls. User transaction, if any, will be rolled back.

SQL Server Error Msg 25659 – The %S_MSG, “%.*ls”, encountered a configuration error during initialization. The customizable attribute %ls is used internally only.

SQL Server Error Msg 41802 – Cannot drop the last memory-optimized container ‘%.*ls’.

SQL Server Error Msg 6834 – XMLTEXT field ‘%.*ls’ contains an invalid XML document. Check the root tag and its attributes.

SQL Server Error Msg 10764 – Number of grouping columns in the query exceeded maximum number allowed. SQL Server allows 64k grouping columns. Reduce number of grouping columns and re-run the query.

SQL Server Error Msg 5702 – SQL Server is terminating this process.

SQL Server Error Msg 14394 – Only owner of a job schedule or members of sysadmin role can modify or delete the job schedule.

SQL Server Error Msg 18364 – Reason: Password did not match that for the user provided. [Database: ‘%.*ls’]

SQL Server Error Msg 6583 – Assembly ‘%.*s’ cannot be used for creating SQL objects because it is a system assembly.