SQL Server 2000 Fulltext search error

• abhisheksharmacnn

  Say Hey Kid

  Points: 713

  More actions

  February 19, 2013 at 12:18 am

  #98810

  Hi,

  I have Windows server 2003 SP2, with SQL server 2000 SP4.

  Server has 36 GB ram (min-max set to 32 GB), AWE enabled, Lock pages in memory enabled.

  While running following template of the query i get following error:

  select Count(1) from table_name WHERE CONTAINS(INFO, 'abc')

  output:

  Server: Msg 7399, Level 16, State 1, Line 1

  OLE DB provider 'Full-text Search Engine' reported an error. The provider ran out of memory.

  [OLE/DB provider returned message: Not enough storage is available to complete this operation.]

  OLE DB error trace [OLE/DB Provider 'Full-text Search Engine' IRowset::GetNextRows returned 0x8007000e: The provider ran out of memory.].

  Please assist.