Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2000 Fulltext search error Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 12:18 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 25, 2013 2:05 AM
Points: 488, Visits: 48
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 »

Add to briefcase

Permissions Expand / Collapse