SQL Server

SQL Server Error Msg 2011 – Index hints within a schema-bound object can be applied only to memory optimized tables.

SQL Server Error Msg 6628 – %.*ls can only process untyped XML. Cast the input value to XML or to a string type.

SQL Server Error Msg 20084 – Publication ‘%s’ cannot be subscribed to by Subscriber database ‘%s’.

SQL Server Error Msg 4843 – The bulk data source provider string has a syntax error (‘%lc’) near character position %d.

SQL Server Error Msg 2203 – %sOnly ‘http://www.w3.org/2001/XMLSchema#decimal?’, ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed as predicates, found ‘%ls’

SQL Server Error Msg 41038 – Failed to enumerate Windows Server Failover Clustering (WSFC) objects (Error code %d).  If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster object enumeration handle is invalid.  Otherwise, contact your primary support provider.  For information about this error code, see “System Error Codes” in the Windows Development documentation.

SQL Server – Limit rows with OFFSET & FETCH

SQL Server Error Msg 1458 – The principal copy of the ‘%.*ls’ database encountered error %d, status %d, severity %d while sending page %S_PGID to the mirror. Database mirroring has been suspended. Try to resolve the error condition, and resume mirroring.

SQL Server Error Msg 976 – The target database, ‘%.*ls’, is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read access to one or more secondary availability replicas in the group.  For more information, see the ALTER AVAILABILITY GROUP statement in SQL Server Books Online.

SQL Server Error Msg 35244 – Database ‘%.*ls’ cannot be added to availability group ‘%.*ls’.  The database is currently joined to another availability group.  Verify that the database name is correct and that the database is not joined to an availability group, then retry the operation.

SQL Server Error Msg 2714 – There is already an object named ‘%.*ls’ in the database.

SQL Server Error Msg 5193 – Failed to access file due to lease mismatch. Bringing down database.

SQL Server Error Msg ALTER TABLE SWITCH statement failed on table ‘%.*ls’ because column ‘%.*ls’ does not have the same GENERATED ALWAYS attribute in target and source tables. – 16

SQL Server Error Msg 22565 – uses other than day as unit of retention period

SQL Server Error Msg 1483 – State information for database ‘%.*ls’ – Hardened Lsn: ‘%S_LSN’    Commit LSN: ‘%S_LSN’    Commit Time: ‘%S_DATE’

SQL Server Error Msg 8637 – The query processor could not produce a query plan because a USE PLAN hint was used for a query that modifies data while the target table of the modification has an index that is currently being built online. Consider waiting until the online index build is done before forcing the plan, or using another way to tune the query, such as updating statistics, or using a different hint or a manual query rewrite.

SQL Server Error Msg 3903 – The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

SQL Server Error Msg 20578 – Replication: agent custom shutdown

SQL Server Error Msg 49933 – ERROR: The MSSQL_SA_PASSWORD environment variable must be set when using the –reset-sa-password option.

SQL Server Error Msg 21311 – Profile used by the Merge Agent to perform rowcount and checksum validation.