#30 Orphaned Document Versions

[Simon Woodman]

It appears that it is possible to orphan document versions. For instance, see the following query which shows all DVs who don't have a corresponding DR:

select * from documentversions as dv where dv.documentrecordid not in (select id from objectsflat where objecttype = 'DOCUMENTRECORD')