Hi, group,
Made these days some tests and not understand very clear how contains or
containstable perform the search.
The catalog was built on 2...5 columns, various scenarios.

I need to do a sum this way : Select Field1, Sum(Field2) as sumField2 From
Table1 Group By Field1. I think the syntax is correct, but the problem is
that Field1 is of type Text (and not varchar). So I receive an error telling
me I can't "group by" with a field of type "Text". Is ...

I perform a query against a database and it returns one set of results.  I
perform this query on an "identical" database and it returns a subtly
different set of results.
In detail.

I would welcome opinions on whether FTS would help in our scenario.
The table has about 28 million rows and has about 10,000 rows added every
morning in an intensive batch process. Then another batch query process is
run that looks for partial name matches.

I have a full-text index on a Title column in a Books table and I have a
CONTAINSTABLE query that seems to work well in most cases.  Recently I
discovered that the query was failing to return an expected result.  When I
search for titles containing the word "shining," I expect ...

Does anyone know a simple way to highlight matches using full text indexes
in SQL Server 2005?
[]´s
José

My OS is Windows XP Professional 2002, when i'm trying to install the
Server Components for the FULL TEXT INDEXING using the SQL Server
Standard Edition CD, prior to the installation it is giving a message
saying "Microsoft SQL Server 2000 Standard Edition server component is

Getting the following error in SQL 2005 :
Msg 7696, Level 16, State 10, Line 1
Invalid locale ID was specified. Please verify that the locale ID is correct
and corresponding language resource has been installed.

Running on Sql Server 2000, I have a catalog set to do an incremental
populate every 5  minutes each day.
But when I make a change to a record and do a search on it, it doesn't find
it, even after about 20 minutes.  But if I manually do the incremental

Can u install FTS later on? I have a clustered env. and due to failure in
registering FTS the entire install is rolling back? so perhaps I can delete
the FTS Resource and install it later...
TIA

We are running SQL 2000 sp4 with full text search, recently we are
getting 100% CPU over extended period of time and the only way to
resolve this is by killing the Mssearch.exe process. (we tried to
restart the service but it hang) the Microsoft search service is

Active-active cluster. The second node was reinstalled after a hardware
failure.
The MS Search service is started.
But when I try to query full-text the error message shows up:

How to find full text index is exist in the table or not ?
like that how to find normal index is exist in the table or not ?
Thanks in adv.
---> Murali <----

When submitting this Querey in SQL Server 2005
SELECT FT_TBL.Firstname, FT_TBL.LastName, Key_TBL.Rank
FROM [user] AS FT_TBL INNER JOIN
  CONTAINSTABLE([user], Firstname, 'ISABOUT (Christian weight (.1), Ian

Hi Gyus,
         I have a quick question. Can you run full text search on a column
tha contains ntext data?
Thanx..