USP_GLOBALCHANGECATALOG_AVAILABLEGLOBALCHANGES

                CREATE procedure [dbo].[USP_GLOBALCHANGECATALOG_AVAILABLEGLOBALCHANGES]
                as                
                    set nocount on;

                    select 
                        GLOBALCHANGECATALOG.ID as GLOBALCHANGEID, 
                        GLOBALCHANGECATALOG.DISPLAYNAME,                    
                        GLOBALCHANGECATALOG.GLOBALCHANGEFOLDER,
                        GLOBALCHANGECATALOG.GLOBALCHANGESPECXML
                    from 
                        dbo.GLOBALCHANGECATALOG                
                    where
                        coalesce(DISPLAYNAME,'') <> ''
                    order by 
                        GLOBALCHANGECATALOG.GLOBALCHANGEFOLDER, GLOBALCHANGECATALOG.DISPLAYNAME