The issue you have with Ektron is that when you update the Is Searchable
checkbox on a folder, it is for all future content. Existing content is left as
is. The SQL will update the Is Searchable to the parent folders setting.
DECLARE @folderID int
DECLARE @searchable int
--------------------------------------------------------
DECLARE