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.