Full text search returns no results

• sarank

  Newbie

  Points: 3

  More actions

  December 20, 2002 at 2:47 am

  #79421

  Hai everybody,

  I have a table with text column. The structure is

  TblData

  -----------

  LngIdnumeric(20)

  VchNameVarchar(100)

  VchEmailVarchar(100)

  TxtDataText

  VchRemarksVarchar(1000)

  I have created a catalog in the DB and added the table and column. I also started the full population of catalog. But when i issue a query(like the one i have given here) no data is returned even if theres a matching row. No error is also reported.

  select * from TblData where CONTAINS(TxtData,'ASP')

  But when i issue a simple query like

  select * from TblData

  rows are returned.Pls help me.

  Regards,

  Saravanan K

  Regards,

  K.Saravanan

  
  Regards,
  K.Saravanan

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  December 20, 2002 at 2:50 am

  #444910

  Hi, try: -

  select * from TblData where CONTAINS(TxtData,'"ASP*"')

  (i.e. '"ASP*"' and not 'ASP')

  Regards,

  Andy Jones

  .

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  December 20, 2002 at 7:35 am

  #444925

  Verify whether login BUILTIN\Administrators has been removed. If it does, you have to grant system account [NT Authority\System] to access your SQL Server with 'sa' righr.