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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.