Category: SQL Server

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…

SQL Server Error Code – 33440 when inserting into filetable ‘%.*ls’ us

In this blog post, you’ll learn more about the SQL Server Error Code 33440 and the error message description that is shown SQL Server Error Code 33440 SQL Server Error Description for the Code :33440 When inserting into FileTable ‘%.*ls’ using BCP or BULK INSERT, either CHECK_CONSTRAINTS option needs to be on, or FILETABLE_NAMESPACE needs to be disabled on the table.

SQL Server Error Code – 33446 the filestream database configuration ca

In this blog post, you’ll learn more about the SQL Server Error Code 33446 and the error message description that is shown SQL Server Error Code 33446 SQL Server Error Description for the Code :33446 The FILESTREAM database configuration cannot be changed for database ‘%.*s’.  The database is either a mirror database in Database Mirroring, or is in a secondary replica of an Always On…