Select The latest result for each root categories with their childs category:

WITH LatestResult AS

(SELECT result.*,

ROW_NUMBER() OVER(PARTITION BY result.RootParentID ORDER BY result.PublishedTime DESC) AS RowNo

FROM Tracker.GetResultWithRootParent() result

WHERE result.[Status] != 255)

SELECT...

yes.

we logged in as administrator user and have full access.

I haven't problem with create a new DB and adding other File Groups and Files

my problem is only with FileStream.

Thanks for your reply.

I enabled FileStream feature

this problem is only for one server in my organization and other servers work without problem.

Please Help Me...