select
    C.Collectionid,
    C.Name
from
    dbo.v_Collection C
Where
    C.Collectionid not in (Select Collectionid from dbo.v_FullCollectionMembership)