Hi all...
Someone testing the Search program I am putting together brought this to my
attention today.
The Contains clause is:

Where is the log full-text error log
   FULLTEXTCATALOGPROPERTY('MyCatalogName', 'LogSize')
refers to in SQL Server?
"Size, in bytes, of the combined set of error logs associated with a

ran into the following case when using the near full text search
feature with SQL 2005:
The following string is stored in a table in an nvarchar(max) type
column and a full text index is built on it using english:

2005 sql server on Win2003
SQL fulltext Queries (and stored procedures) all of a sudden have stopped
working.  We are running these queries and sp's from a web site through an
ADO connection.  Dynamic sql works fine.

This is my problem, I hope you can help me...
I have an asp web site.
I want to search, for exemple in a table of addresses, the string
"apple+table", to have all the record in my table where in a list of fields

1. Create a robust search engine able searching of information across all
types of content.
2. Support Open Search specification
3. content indexer applying A-Z indexing model and establish keyword

I have a list of internet URLs in an SQL table.
If a user enters a URL in to a web page to be added to the URLList table, I'd like to know if that URL is already in the table.
This is my query.
rs.Open "SELECT * FROM URLList WHERE URL LIKE '[" & MyURL & "]%' ORDER BY URL ASC", conn, ...