Snippets
20

Clear all page level skins in a Portal

update {databaseOwner}{objectQualifier}Tabs
set skinsrc=null
where SkinSrc is not null
and PortalID=0

 

Clear all page level containers in a Portal

update {databaseOwner}{objectQualifier}tabs
set containersrc=null
where containersrc is not null
and PortalID=0

 

Clear all module level containers in a Portal

update {databaseOwner}{objectQualifier}TabModules
set ContainerSrc = null
where TabModuleID in (select TabModuleId
    from {databaseOwner}{objectQualifier}TabModules tm
    join {databaseOwner}{objectQualifier}Modules m
            on (tm.ModuleID = m.ModuleID)
    where ContainerSrc is not null
    and m.PortalId=0)

Posted in: DNN, SQL Scripts

Post Rating

Comments

There are currently no comments, be the first to post one!

Post Comment

Only registered users may post comments.

120 OLD FREEMANS WAY, BREWSTER, MA 02631
MAILING: P.O. BOX 2342, BREWSTER, MA 02631
PHONE (774) 323-3176