I've used it in the past with no effect on performance. Full-text indexing is handled by a seperate service, MSSearch. The indexes are external to SQL Server and must be periodically refreshed. In all, it's a very neat. It's worth looking into.

-Mike

>Do you use any full-text indexing? How does it affect overall server performance?
>
>
>
>>You can search a text column. You can't index it. Well OK you can. The Full-Text Indexing can index a text column.
>>
>>SELECT OBJECT_NAME(id) FROM syscomments WHERE text LIKE '%procedure%'
>>
>>-Mike