DROP PROCEDURE {databaseOwner}{objectQualifier}DMX_GetAllPortalCollections
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}DMX_GetAllPortalCollections
  @PortalId Int
AS

SELECT {objectQualifier}DMX_Entries.Description, {objectQualifier}DMX_Entries.EntryId, {objectQualifier}DMX_Entries.CollectionId, {objectQualifier}DMX_Entries.EditRoles
FROM {objectQualifier}DMX_Entries
WHERE ((({objectQualifier}DMX_Entries.EntryType) LIKE 'Collection') AND ((NOT {objectQualifier}DMX_Entries.Deleted = 1)) AND (({objectQualifier}DMX_Entries.PortalId)=@PortalId))
ORDER BY {objectQualifier}DMX_Entries.Description

GO
