fnAllObjects

        CREATE   FUNCTION dbo.fnAllObjects 
        (
        )
        RETURNS TABLE
        AS
            RETURN (
        select 1 as type, id, title as [name], guid from [dbo].sitecontent
        union
        select 2 as type, id, pagename as [name], guid from [dbo].sitepages where istemplatepage=0
        union
        select 3 as type, id, pagename as [name], guid from [dbo].sitepages where istemplatepage=1
        union
        select 4 as type, id, name, guid from [dbo].siteimages
        union 
        select 6 as type, id, username as name, guid from [dbo].clientusers
        union 
        select 7 as type, id, name, guid from [dbo].clientroles
        union 
        select 8 as type, id, name, guid from [dbo].clientsites
        union 
        select 9 as type, id, name, guid from [dbo].clients
        union
        select 10 as type, id, 'Donation', guid from [dbo].clientdonations
        union
        select 11 as type, id, name, guid from [dbo].clientuserimages
        union
        select 12 as type, id, name as name, guid from [dbo].EmailList
        union
        select 14 as type, id, name, guid from [dbo].EmailTemplate
        union
        select 15 as type, id, name, guid from [dbo].Email
        union
        select 16 as type, id, 'Event', guid from [dbo].clientevents
        union
        select 17 as type, id, name, guid from [dbo].sitelayouts
        union
        select 18 as type, id, name, guid from [dbo].clientclassyears
        union
        select 20 as type, id, name, guid from [dbo].docuploadpart
        union
        select 21 as type, id, groupname as name, guid from [dbo].discussiongroups
        union
        select 22 as type, id, jobboardname as name, guid from [dbo].jobboards
        union
        select 24 as type, id, 'Membership', guid from [dbo].clientmemberships
        union
        select 25 as type, id, givinghistoryname as name, guid from [dbo].givinghistory
        union
        select 26 as type, id, newsreaderurl as name, guid from [dbo].newsreaders
        union
        select 27 as type, id, title as name, guid from [dbo].newschannels
        union
        select 30 as type, id, name, guid from [dbo].sitestylesheets
        union
        select 31 as type, ID, Description, EntryGUID from [dbo].SiteCodeTableEntries where CodeTablesID = 1
        )