Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server 2000 Fulltext search error Expand / Collapse
Posted Tuesday, February 19, 2013 12:18 AM


Group: General Forum Members
Last Login: Thursday, April 14, 2016 3:33 PM
Points: 489, Visits: 53

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')


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.
Post #1421450
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse