• If you are only filtering the columns in the publication, then you shouldn't have any problems. You must be doing something wrong if the fileds gtes shifted.

    Everytime you made changes to the publication, you better drop and re create the publication, to avoid problems.

    "DROP the existing table & recreate it" will apply each time the snapshot agent is run. Like this is a snapshot publication, then it will run everytime you try to replicate.

    To understand what is the snapshot that applies to the subscriber, you can open and also edit, the files that SQL created in the snapshot folder.