Tag: SQL Server Errors

SQL Server Error Msg 17073 – Executing ‘sp_server_diagnostics’ stored procedure in repeat mode with ‘insert into’ clause is not allowed.

SQL Server Error Msg 49801 – Dynamic Deactivation Timer task encountered an error (SQL Error Code: %d).  Refer to the xel for more details.

SQL Server Error Msg 41091 – Always On: The local replica of availability group ‘%.*ls’ is going offline because either the lease expired or lease renewal failed. This is an informational message only. No user action is required.

SQL Server Error Msg 45142 – IsForcedTerminate cannot be set while creating a database copy.  This can only be updated on the source server after it is created.

SQL Server Error Msg 11608 – Creating temporary stored procedures is not allowed.

SQL Server Error Msg 22555 – Cannot set the retention period unit to a value other than “day” for publication “%s” because it uses the sync_mode of “character” and may have SQL Server Compact Edition subscribers.

SQL Server Error Msg 46527 – Altering the ‘%S_MSG’ property is not permitted for an external data source of type %ls.

SQL Server Error Msg 1755 – Defaults cannot be created on columns of data type timestamp. Table ‘%.*ls’, column ‘%.*ls’.

SQL Server Error Msg 19246 – Incomplete message error is returned from SSPI but failed to proceed.

SQL Server Error Msg 33168 – TYPE option cannot be used along with FOR/FROM LOGIN, CERTIFICATE, ASYMMETRIC KEY, EXTERNAL PROVIDER, WITHOUT LOGIN or WITH PASSWORD, in this version of SQL Server.

SQL Server Error Msg 40001 – Secondary kill was initiated during commit.

SQL Server Error Msg 17198 – Connection failed because the endpoint could not be found. This may result if an endpoint is dropped while a connection attempt is in progress. Attempt to connect to a different endpoint on the server.%.*ls

SQL Server Error Msg 40140 – Set partition failed since a different partition already was set in the current transaction. Cross partition operations within a node are not reliable or supported.

SQL Server Error Msg 5073 – Cannot alter collation for database ‘%ls’ because it is READONLY, OFFLINE, or marked SUSPECT.

SQL Server Error Msg 22919 – One or more columns in the list of columns needing update flags was not a captured column of the change table %s.

SQL Server Error Msg 27256 – The event message does not exist.

SQL Server Error Msg 1846 – Cannot find SQL Volume Shadow Copy (VSS) Writer component for database ‘%ls’ while creating auto-recovered VSS snapshot for online DBCC check.

SQL Server Error Msg 15660 – Compressing XML, spatial, columnstore or hash indexes is not supported by the stored procedure sp_estimate_data_compression_savings.

SQL Server Error Msg 7724 – Computed column cannot be used as a partition key if it is not persisted. Partition key column ‘%.*ls’ in table ‘%.*ls’ is not persisted.

SQL Server Error Msg 6838 – Attribute-centric IDREFS or NMTOKENS field not supported on tags having element-centric field ‘%.*ls’ of type TEXT/NTEXT or IMAGE.  Either specify ELEMENT on IDREFS/NMTOKENS field or remove the ELEMENT directive.