Hi,
Thanks for your comments, we do drop & recreate the views, but I am at a loss to why the recreate dropped one field out of three on 2 of the sites.

Any ideas?

>>Hi,
>>Is there a utility to check the sync of the DBC after doing a structural update. i.e. at a remote site.
>>The reason being we recently completed Version upgrade of our clients, and 2 out of 500 sites didn't update 1 of 3 changes to an existing view, and no errors were reported during the update.
>
>Neil,
>For views simply drop and recreate them in code. However each drop&add bloats the DBC (deletes old and adds new). A fresh new DBC and tables were our solution.
>Cetin