Category: SQL Server

SQL Server Error Code – 13519 setting system_versioning to on failed b

In this blog post, you’ll learn more about the SQL Server Error Code 13519 and the error message description that is shown SQL Server Error Code 13519 SQL Server Error Description for the Code :13519 Setting SYSTEM_VERSIONING to ON failed because history table ‘%.*ls’ has computed column specification. Consider dropping all computed column specifications and trying again.

SQL Server Error Code – 28978 configuration manager agent cannot ‘%s’

In this blog post, you’ll learn more about the SQL Server Error Code 28978 and the error message description that is shown SQL Server Error Code 28978 SQL Server Error Description for the Code :28978 Configuration manager agent cannot ‘%s’ ‘%s’. Examine previous logged messages to determine cause of this error. This is a fatal error affecting system functionality and brick will be taken down.

SQL Server Error Code – 30052 the full-text query has a very complex n

In this blog post, you’ll learn more about the SQL Server Error Code 30052 and the error message description that is shown SQL Server Error Code 30052 SQL Server Error Description for the Code :30052 The full-text query has a very complex NEAR clause in the CONTAINS predicate or CONTAINSTABLE function. To ensure that a NEAR clause runs successfully, use only six or fewer terms….

SQL Server Error Code – 21766 table %s contains an identity column tha

In this blog post, you’ll learn more about the SQL Server Error Code 21766 and the error message description that is shown SQL Server Error Code 21766 SQL Server Error Description for the Code :21766 Table %s contains an identity column that is marked as Not For Replication, but the @identitymanagementoption parameter of sp_addarticle is set to ‘none’. To support immediate updating subscriptions, specify a…

SQL Server Error Code – 30098 an internal query to load data for a cra

In this blog post, you’ll learn more about the SQL Server Error Code 30098 and the error message description that is shown SQL Server Error Code 30098 SQL Server Error Description for the Code :30098 An internal query to load data for a crawl on database ‘%.*ls’ and table ‘%.*ls’ failed with error code %d. Check the sql error code for more information about the…

SQL Server Error Code – 21758 cannot find a valid queue reader agent i

In this blog post, you’ll learn more about the SQL Server Error Code 21758 and the error message description that is shown SQL Server Error Code 21758 SQL Server Error Description for the Code :21758 Cannot find a valid Queue Reader Agent ID for the subscription to Publisher %s, database %s, publication %s. The specified subscription to an updating Subscriber publication is not initialized. Run…

SQL Server Error Code – 46916 queries that reference external tables a

In this blog post, you’ll learn more about the SQL Server Error Code 46916 and the error message description that is shown SQL Server Error Code 46916 SQL Server Error Description for the Code :46916 Queries that reference external tables are not supported by the legacy cardinality estimation framework. Ensure that trace flag 9481 is not enabled, the database compatibility level is at least 120…