Category: SQL Server

SQL Server Error Code – 21839 article ‘%s’ can not support schema_opti

In this blog post, you’ll learn more about the SQL Server Error Code 21839 and the error message description that is shown SQL Server Error Code 21839 SQL Server Error Description for the Code :21839 Article ‘%s’ can not support schema_option 0x20 or 0x2000000000 because it contains computed column, check/default constraint or primary key which is based on CLR type column, change @schema_option setting and…

SQL Server Error Code – 41039 an availability group replica already ex

In this blog post, you’ll learn more about the SQL Server Error Code 41039 and the error message description that is shown SQL Server Error Code 41039 SQL Server Error Description for the Code :41039 An availability group replica already exists on the node ‘%.*ls’.  Each node can contain only one replica of an availability group.  Please choose another node to host the new replica.

SQL Server Error Code – 19506 local availability replica for availabil

In this blog post, you’ll learn more about the SQL Server Error Code 19506 and the error message description that is shown SQL Server Error Code 19506 SQL Server Error Description for the Code :19506 Local availability replica for availability group ‘%.*ls’ has not been granted permission to create databases, but has a SEEDING_MODE of AUTOMATIC. Use the ALTER AVAILABILITY GROUP … GRANT CREATE ANY…