SQL Server 2000 Fulltext search error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » SQL Server 2000 Fulltext search error

SQL Server 2000 Fulltext search error

Rate Topic

Display Mode

Topic Options

Author

Message

abhisheksharmacnn

Posted Tuesday, February 19, 2013 12:18 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, March 06, 2013 10:59 PM
Points: 459, Visits: 47

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.

Post #1421450

« Prev Topic | Next Topic »

Permissions