Well our problem is that iFilter can't be changed for TEXT column types.

As Hilary Cotter's web page states:

For columns of the CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, and NTEXT data types...

Detach is not a problem as copied data base is just a template.

Backup - Restore does not work (at least not with SQL Server Manager) because I'm trying to create...

Problem solved.

SUM(CONVERT(int,(ISNULL(A.RANK, 0) + ISNULL(A.RANK, 0))) AS TOTALRANK

did the trick

Thank you all for your ideas. I think that Paul Rubel is on right track when succesting that SP is being recompiled.

dbo.GetChilds function is actually a bit hazardous and it's...