Full text service user account

Folks,
Just a quick one. How do you determine the user that the full text
service is using on SQL Server 2000? Any suggestions/code sample
diagnostics much appreciated.
Thanking you,
Al.
It has to use a local system account. If you have it run under a user
account it will not work.
On Dec 13, 6:21 am, "almu...@.altavista.com" <almu...@.altavista.com>
wrote:
> Folks,
> Just a quick one. How do you determine the user that the full text
> service is using on SQL Server 2000? Any suggestions/code sample
> diagnostics much appreciated.
> Thanking you,
> Al.

Full Text Search (2005) - How to determine word offset in CONTAINS query?

Does anyone know if it is possible to determine the relative word offset (the Occ) from a simple-term query such as:-

SELECT Comments
FROM Production.ProductReview
WHERE CONTAINS(Comments, ' "mountain biking" ');

So, given the text:-

"Maybe it's just because I'm new to mountain biking, but I had a terrible time getting used to these pedals."

I would like the query would return both the text and the word offset of 8. To me, it seems like this would be quite useful as I want to highlight the found text for the user to see. Obviously I can do a post-SELECT scan of the string to find the values but this would seem unnecessary.

If anyone can give me any pointers I'd be very grateful.

Thanks

You may want to post this on the database engine forum (for full-text search) - http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=93 since this is not a SQL Server Data Mining feature.|||I think I will, but I wasn't sure where to post the question as there isn't an FTS forum (yet!). Thanks for your suggestion.sql