I have this strange behaviour with fulltext search: I have a keywords field
which is used for full text indexing.
In one row I have the keyword 'geography' (without ', of course). If I
search with:

I am using SQL server 2005. I have added some tables to a catalog
(they have auto increment PK, timestamps and change tracking is
enabled). The database was backed up/restored from SQL server 2000 to
SQL server 2005.

I was restoring a database in SQL Server 2005 express edition. Due to a
malfunction, system restarted.
Now when I try to access the database, the status shows as "Restoring
Database". I have tried to restart SQL Server and PC, but there is no

I have a simple music catalog:
CREATE TABLE [dbo].[Catalog](
       [CatalogId] [int] IDENTITY(1,1) NOT NULL,
       [Artist] [nvarchar](256) NULL,

I am pretty new to FTS but found I am stuck with a problem that
doesn't seem common.  In all my searching, I have only come across one
post that had the same issue and that was from 2002.
http://groups.google.com.au/group/microsoft.public.sqlserver ...

I have a table which has a record  T17.1.516.32
I try
SELECT Urun_Ad as guUrun_Ad
FROM TBL_URUNLER

I am creating a Full-Text Search application for a Visual Basic
project and am having a problem with my sql query when I try to use
filtering on a proximity search and try to order the results.
I start with a simple CONTAINS FTS that is filtered and ordered.  It

I have enabled full-text search on ProductName column of my Products table,
using ProductId (PK) as key.
My asp.net web aoolication, filters the search (remove none alpha-numeric
and unwanted chars) and pass it as parameter to the stored procudure.