Jamal,
Upon further review I think my original idea (DBO user related) was incorrect.
For the dataset that is failing, does it contain any user defined fields?
Can you try adding a field to the table before you register it as versioned?
E.g., the field set would contain ObjectID and myTextField
The view is correctly created for me when using a DBO mapped user if the table has more fields that just the default ObjectID field (a questionably useful table schema).
Thanks,
Colin
Many thanks guys for the help.Colin�?�it worked as a charm. Adding fields (other than the defaults) to tables before applying the �??register as version�?� solves the issue. Interestingly, if a table is �??registered as version�?� before adding fields then the version view is not created. In this case, unregistering this table and re-registering it will create the version view provided that other fields are created before applying the registration.Very much appreciatedJamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine