Category: SQL Server

SQL Server Error Code – 41386 filegroups with memory_optimized_data, m

In this blog post, you’ll learn more about the SQL Server Error Code 41386 and the error message description that is shown SQL Server Error Code 41386 SQL Server Error Description for the Code :41386 Filegroups with MEMORY_OPTIMIZED_DATA, memory-optimized tables and natively compiled modules are not supported when lightweight pooling is enabled. Disable lightweight pooling in order to use memory-optimized features.

SQL Server Error Code – 41387 disallowing page allocations for databas

In this blog post, you’ll learn more about the SQL Server Error Code 41387 and the error message description that is shown SQL Server Error Code 41387 SQL Server Error Description for the Code :41387 Disallowing page allocations for database ‘%.*ls’ due to insufficient memory in the resource pool ‘%ls’. See ‘http://go.microsoft.com/fwlink/?LinkId=510837’ for more information.

SQL Server Error Code – 8722 cannot execute query. semantic affecting

In this blog post, you’ll learn more about the SQL Server Error Code 8722 and the error message description that is shown SQL Server Error Code 8722 SQL Server Error Description for the Code :8722 Cannot execute query. Semantic affecting hint ‘%.*ls’ appears in the ‘%.*ls’ clause of object ‘%.*ls’ but not in the corresponding ‘%.*ls’ clause.  Change the OPTION (TABLE HINTS…) clause so the…

SQL Server Error Code – 21774 this procedure is supported only for non

In this blog post, you’ll learn more about the SQL Server Error Code 21774 and the error message description that is shown SQL Server Error Code 21774 SQL Server Error Description for the Code :21774 This procedure is supported only for non-SQL Server Publishers. The Publisher ‘%s’, on which you are executing the procedure, is a SQL Server Publisher.

SQL Server Error Code – 21884 the query at the redirected publisher ‘%

In this blog post, you’ll learn more about the SQL Server Error Code 21884 and the error message description that is shown SQL Server Error Code 21884 SQL Server Error Description for the Code :21884 The query at the redirected publisher ‘%s’ to determine the health of the availability group associated with publisher database ‘%s’ failed with error ‘%d’, error message ‘%s’.

SQL Server Error Code – 1464 database ?%.*ls? is not in a recovering

In this blog post, you’ll learn more about the SQL Server Error Code 1464 and the error message description that is shown SQL Server Error Code 1464 SQL Server Error Description for the Code :1464 Database ?%.*ls? is not in a recovering state which is required for a mirror database or secondary database. The remote database must be restored using WITH NORECOVERY.