The table names are changed

our requirment is

the production table is large around 40 million rows

the current query uses a like search which takes huge amount of...

no improvement

No , its not showing any status . shows only rebuild.

any guess abt this problem

The First Query gave me 1734 rows

using FREETEXT gave me just 24 rows

kinldy guide me how to check whether the catlog is build fully or not.

the catlog size...

From your r query it seems the Degree of Parallelism has been acheived

check the following link ,

http://msdn.microsoft.com/en-us/library/ms175097.aspx

The code u have added doesn't seem to have logical problems ,

u have to do these for more investigation on this scenario

Add Full code as an attachment...

Thanks for u r timely help,

its working fine

Yes but our application use views and user defined datatypes. , The collate query cant be used across all queries

When server collation and db collation differs , the view fails

The DB was deployed from a Back up , so the error has come ,

we was searching for...