Category: SQL Server

SQL Server Error Code – 22117 for databases that are members of a seco

In this blog post, you’ll learn more about the SQL Server Error Code 22117 and the error message description that is shown SQL Server Error Code 22117 SQL Server Error Description for the Code :22117 For databases that are members of a secondary availability replica, change tracking is not supported. Run change tracking queries on the databases in the primary availability replica.

SQL Server Error Code – 11731 a column that uses a sequence object in

In this blog post, you’ll learn more about the SQL Server Error Code 11731 and the error message description that is shown SQL Server Error Code 11731 SQL Server Error Description for the Code :11731 A column that uses a sequence object in the default constraint must be present in the target columns list, if the same sequence object appears in a row constructor.

SQL Server Error Code – 21869 cannot add filter between proposed paren

In this blog post, you’ll learn more about the SQL Server Error Code 21869 and the error message description that is shown SQL Server Error Code 21869 SQL Server Error Description for the Code :21869 Cannot add filter between proposed parent article ‘%s’ and proposed child article ‘%s’ since this would introduce a cycle in the filter relationships.  The proposed parent is already being filtered…

SQL Server Error Code – 1922 filegroup ?%.*ls? has no files assigned

In this blog post, you’ll learn more about the SQL Server Error Code 1922 and the error message description that is shown SQL Server Error Code 1922 SQL Server Error Description for the Code :1922 Filegroup ?%.*ls? has no files assigned to it. Tables, indexes, and large object columns cannot be created on this filegroup. Use ALTER DATABASE to add one or more files to…

SQL Server Error Code – 9242 query notification delivery could not ge

In this blog post, you’ll learn more about the SQL Server Error Code 9242 and the error message description that is shown SQL Server Error Code 9242 SQL Server Error Description for the Code :9242 Query notification delivery could not get dialog endpoint for dialog ‘%.*ls’. Query notification delivery failed because of the following error in service broker: ‘%.*ls’. See the error log for additional…