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