USP_DATALIST_SITEPAGES
This returns a list of all IDs for all non-deleted sites and their ClientSiteID.
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SITEPAGES
as
set nocount on;
select ID,
CLIENTSITESID
from dbo.SITEPAGES
where DELETED = 0