﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Administration / SQL Server 7,2000  / SQL Server 2000 Fulltext search error / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Wed, 19 Jun 2013 07:37:14 GMT</lastBuildDate><ttl>20</ttl><item><title>SQL Server 2000 Fulltext search error</title><link>http://www.sqlservercentral.com/Forums/Topic1421450-5-1.aspx</link><description>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 1OLE 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.</description><pubDate>Tue, 19 Feb 2013 00:18:17 GMT</pubDate><dc:creator>abhisheksharmacnn</dc:creator></item></channel></rss>