Category: SQL Server

SQL Server Error Code – 47143 option ‘reuse_system_databases’ is inval

In this blog post, you’ll learn more about the SQL Server Error Code 47143 and the error message description that is shown SQL Server Error Code 47143 SQL Server Error Description for the Code :47143 Option ‘reuse_system_databases’ is invalid for creating availability group ‘%.*ls’. Option ‘reuse_system_databases’ can only be used with contained availability group. Correct the option and retry the operation.

SQL Server Error Code – 6288 alter assembly has marked data as unchec

In this blog post, you’ll learn more about the SQL Server Error Code 6288 and the error message description that is shown SQL Server Error Code 6288 SQL Server Error Description for the Code :6288 ALTER ASSEMBLY has marked data as unchecked in one or more objects in database “%.*ls”. Refer to column “has_unchecked_assembly_data” from system views “sys.tables” and “sys.views” to locate all such objects.

SQL Server Error Code – 46719 attempt to reset connection with ‘keep t

In this blog post, you’ll learn more about the SQL Server Error Code 46719 and the error message description that is shown SQL Server Error Code 46719 SQL Server Error Description for the Code :46719 Attempt to reset connection with ‘Keep Transaction’ failed because the incoming request was not a commit/rollback request. This error can occur if more than one SqlConnection is used within the…

SQL Server – Saving changes is not permitted. The changes you have made require the following tables to be dropped...

There are times when you get an error stating “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.” You can easily resolve this issue by following the steps mentioned…