Category: SQL Server

SQL Server Error Code – 20730 setting @upload_first to ‘true’ requires

In this blog post, you’ll learn more about the SQL Server Error Code 20730 and the error message description that is shown SQL Server Error Code 20730 SQL Server Error Description for the Code :20730 Setting @upload_first to ‘true’ requires the publication to be at publication_compatibility_level of ’80RTM’ or higher. Use sp_changemergepublication to set publication_compatibility_level to ’80RTM’ or higher if you want to use this…

SQL Server Error Code – 47119 the current write lease of the availabil

In this blog post, you’ll learn more about the SQL Server Error Code 47119 and the error message description that is shown SQL Server Error Code 47119 SQL Server Error Description for the Code :47119 The current write lease of the availability group ‘%.*ls’ is still valid. The lease expiration time cannot be set to an earlier time than its current value.

SQL Server Error Code – 7935 table error: a filestream directory id %

In this blog post, you’ll learn more about the SQL Server Error Code 7935 and the error message description that is shown SQL Server Error Code 7935 SQL Server Error Description for the Code :7935 Table error: A FILESTREAM directory ID %.*ls exists for a column of object ID %d, index ID %d, partition ID %I64d, but that column does not exist in the partition.

SQL Server Error Code – 21280 publication ‘%s’ cannot be subscribed to

In this blog post, you’ll learn more about the SQL Server Error Code 21280 and the error message description that is shown SQL Server Error Code 21280 SQL Server Error Description for the Code :21280 Publication ‘%s’ cannot be subscribed to by Subscriber database ‘%s’ because it contains one or more articles that have been subscribed to by the same Subscriber database at transaction level.

SQL Server Error Code – 33415 filestream directory_name ‘%.*s’ attempt

In this blog post, you’ll learn more about the SQL Server Error Code 33415 and the error message description that is shown SQL Server Error Code 33415 SQL Server Error Description for the Code :33415 FILESTREAM DIRECTORY_NAME ‘%.*s’ attempting to be set on database ‘%.*s’ is not unique in this SQL Server instance. Provide a unique value for the database option FILESTREAM DIRECTORY_NAME to enable…

SQL Server Error Code – 35458 it is part of an always on availability

In this blog post, you’ll learn more about the SQL Server Error Code 35458 and the error message description that is shown SQL Server Error Code 35458 SQL Server Error Description for the Code :35458 it is part of an Always On availability group. Consider removing the database from the availability group, changing the setting, and then adding the database back to the availability group

SQL Server Error Code – 4960 alter table switch statement failed. che

In this blog post, you’ll learn more about the SQL Server Error Code 4960 and the error message description that is shown SQL Server Error Code 4960 SQL Server Error Description for the Code :4960 ALTER TABLE SWITCH statement failed. Check constraint ‘%.*ls’ in source table ‘%.*ls’ is NOCHECK constraint but the matching check constraint ‘%.*ls’ in target table ‘%.*ls’ is CHECK.

SQL Server Error Code – 8963 table error: object id %d, index id %d,

In this blog post, you’ll learn more about the SQL Server Error Code 8963 and the error message description that is shown SQL Server Error Code 8963 SQL Server Error Description for the Code :8963 Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). The off-row data node at page %S_PGID, slot %d, text ID %I64d has…