We have on our setup merge replication between two servers running the same versions of MSSQL server. We have some fields of the
geography datatype and we fix that by converting filestream to
nvarchar(max) for all articles. And it works for a few days (I don't know how many exactly) and again we have the same issue over again. Does anyone here know what is cause of that? Note that we are tracking DDL changes on the whole database and that we don't see any new columns of that type, so there is no change in the database structure (that we are aware of).
Any help with this will be highly appreciated.