Full-Text Search limits

If you want to full-text index a table in a Sql Server 2005 database, there is an internal limit of 2,000,000,000 rows in a full-text catalog.  If I remember correctly, this is the same limit in Sql Server 2000, and perhaps Sql Server 7, but I don't have one of those up and running to check.

Wally

No Comments