Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Documentation

SQL 2005 Full Text Search File Size limitation

I would like to know what the maximum document size is for full text search in SQL 2005.

I found the following in the SQL 2000 Help files, look at the note:

Filtering Supported File Types

When a cell in animage column contains one of certain types of documents, full-text search uses a filter to interpret the binary data. The filter extracts the textual information from the document and submits it for indexing and subsequent querying.

Microsoft? SQL Server? 2000 includes filters for these file extensions: .doc, .xls, .ppt, .txt, and .htm....

Note For full-text indexing, adocument must be less than 16 megabytes(MB) in size and must not contain more than 256 kilobytes (KB) of filtered text.

[884 byte] By [MAXamillion] at [2008-2-23]
«« ActiveSync with webAccess
»» Cloth simulation through physics
# 1

Hi Max,

In SQL Server 2005, full-text indexing is limited only by the available memory resources on the machine. The image or varchar(max) data types can hold up to 2 GB in size. If you have adequate memory resources, you can index a document that is 2 GB in size. For example, a desktop machine with 1GB - 2GB of available memory should be adequate for indexing a 2 GB document.

However, I could not find this information in SQL Server 2005 Books Online, so I'll file a documentation bug so that this information can be added in an updated version of the documentation.

Regards,

Gail

gaile at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Documentation...
SQL Server
SQL Server Documentation

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified