I hope someone can help me with this.  I know how to start a full-text
population in t-sql.  However, I would like to be able to start it via SSMS.  
I right click on the catalog and choose properties.  All options are
available  such as optimize, rebuild, however, repopulate is ...

Why or rather what is the reason for drastic growth of FTDATA? And Can we
shrink this FTDATA?

I'm logging error messages for my ASP.NET application with errors
being emailed to me as they occur.
I continuosly get messages from one of my search pages that uses FTS
with "Execution of a full-text operation failed. A clause of the query

How come when I am doing a CONTAINS search across multiple columns on
a table that I have full text indexed I don't get any matches when one
word is contained in one column and the other word is contained in the
other column in the same row of data?  Here is a query where first

i remove "IT" from noise word and rebuild fulltext
and when i query it won't give error message anymore "Informational: The
full-text search condition contained noise word(s)."
but it return no result

Hi group!
I'm facing the the following problem: I want a full-text indexed column
where records can get inserted constantly when under heavy load. The c#
application (can be distributed) and works multithreaded on the same SQL

Is there any T-SQL script/query to find out is full text search service
precent or not?
For example if i have SQL 2005 Express then no and yes if i have SQL 2005
Express Advanced?

I'm new in SQL and I would like to know whether this is "possible" in SQL or
not: -
Table_A
Field_A1, varchar

I got a problem on searching a keyword with '&'.
I run this query and I got all records with '&'.
select * from freetexttable(table1, *, 'AT&T');
I run this and I got records with AT&T.

I posted this on sqlserver.programming and it was recommended I try this
group.
I am designing a search screen that searches for keywords in Text fields as
well as searching other related tables with fields like Date ranges and

I have full text catalog on my table.
SELECT TOP 10 * FROM MyTable My(NOLOCK)
WHERE CONTAINS My.*, '"a.b.c.d*"')
query execute error;

Hard to find exactly the definition of what I'm looking for in BOL. Let's
explain by example:
This return one row:
SELECT * FROM ContainsTable(Request,*,N'ISSI-2007-01001')

I'm finding that using CONTAINS () and any word or phrase containing
an ' does not work. It seems to split the phrase up instead of doing
an EXACT MATCH search.
example: searching on "computer's technology"

Is it posible that dashes "-" are considering as punctuation when using
CONTAINSTABLE function? It's the behavior I see but I cannot find any text in
BOL that specify this.
This gives lots of rows:

I've got a table SupplierItem with full text catalogue set up on it
and I need to search two columns of it, Description2 and
SupplierItemCode, for any combination of terms entered in any order
with wildcards