Tag: MS SQL Server Error Codes

SQL Server Error Code – 7312 invalid use of schema or catalog for ole

In this blog post, you’ll learn more about the SQL Server Error Code 7312 and the error message description that is shown SQL Server Error Code 7312 SQL Server Error Description for the Code :7312 Invalid use of schema or catalog for OLE DB provider “%ls” for linked server “%ls”. A four-part name was supplied, but the provider does not expose the necessary interfaces to…

SQL Server Error Code – 8386 use of hint “%.*ls” on the target table

In this blog post, you’ll learn more about the SQL Server Error Code 8386 and the error message description that is shown SQL Server Error Code 8386 SQL Server Error Description for the Code :8386 Use of hint “%.*ls” on the target table of INSERT is deprecated because it may be removed in a future version of SQL Server. Modify the INSERT statement to remove…

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…