Checkout some of the Opical Character Recognization (OCR) software vendors:

OmniPage - http://www.scansoft.com/omnipage/standard/

IRIS OCR - http://www.irisusa.com/

and some high-end, production-level (>100 pages per minute?) scanners that work with the OCR...

There are several ways to import / upload a file as this is often a FAQ. Below are just of few of KB articles that describe how to do this....

Helen

As the SQL 2000 BOL title "sp_fulltext_catalog" states that "Only members of the sysadmin fixed server role and the db_owner (or higher) fixed database roles can execute sp_fulltext_catalog", you're...

Claudio,

When you say that you "have index sizes (in Mb) of 375, 27, 36 and corresponding log sizes of 100, 101, 201."

Do you mean three separate Full-Text Catalogs (FTC) for...

Jim, et al.,

While using system tables is Ok in SQL 2000, in future version of SQL Server (2005 or Yukon), it is best to use existing metadata functions, for example:

Mark,

There are a couple ways of doing using SQL Full-Text Search (SQL FTS) to search across mutiple tables using either CONTAINSTABLE or FREETEXTTABLE, below is a blog entry that covers...

Gift,

While Microsoft's implementation of CONTAINS may be proprietry, CONTAINS is actually part of the SQL/MM standard, specificlly:

The SQL/MM spec for Full-Text Search is maintained under: "Information technology -- Database...

Actually, CONTAINS is not proprietry to Microsoft as it is in the SQL/MM spec for Full Text Search. Is is how Microsoft SQL Server implments Full Text Search (FTS) within...

Amy,

In your first reply, you stated that you "...have similar queries on other servers that work with the exact same syntax." So, this syntax error only occurs on one server....

Rob,

Both Mark and Jon are correct. "Change Tracking" with "Update Index in Background" enabled is what you're looking for a method to keep the FT Catalogs current with your FT-enabled...

Brian,

Yes, I can. However, I need to know more about exactly what happend between the time SQL Full-text Indexing (FTI) was functional and when it stopped working...

First of all, could...

In addition to who ever owns the job, the owner needs higher permissions (DBO) than just read and write privileges the ability to execute sp_start_job within the msdb on the same server....

You're welcome, Afro,

Much like the "flight envelope" of an aircraft that defines the flight characters of that plane, i.e., at such an altitude and speed the plan is flyable, and...

I'm going to post direct replies to your questions, vs. a grand strategy...

1) When should I use a varchar, and when should I use a text field?

A. You should use...

Jim,

First of all, thank you for providing the SQL INFO (@@version) as this always most helpful in troubleshooting SQL FTS issues!

Secondly, the behavior you are seeing is correct and by...