Tag: MS SQL Server Error Codes

SQL Server Error Code – 20717 sp_addmergelogsettings failed to add log

In this blog post, you’ll learn more about the SQL Server Error Code 20717 and the error message description that is shown SQL Server Error Code 20717 SQL Server Error Description for the Code :20717 sp_addmergelogsettings failed to add log settings. If log settings already exist for this subscription then use sp_changemergelogsettings to change the settings or sp_dropmergelogsettings to remove the settings.

SQL Server Error Code – 22554 cannot change publication “%s” to use th

In this blog post, you’ll learn more about the SQL Server Error Code 22554 and the error message description that is shown SQL Server Error Code 22554 SQL Server Error Description for the Code :22554 Cannot change publication “%s” to use the sync_mode of “character” because it uses a retention period unit other than “day”. Use sp_changemergepublication to set the retention period unit to “day”.

SQL Server Error Code – 35314 the statement failed because a columnsto

In this blog post, you’ll learn more about the SQL Server Error Code 35314 and the error message description that is shown SQL Server Error Code 35314 SQL Server Error Description for the Code :35314 The statement failed because a columnstore index cannot be created on a column set. Consider creating a nonclustered columnstore index on a subset of columns in the table that does…