http://www.windowsitpro.com/authors/author/author/5777574/rsscomment/5777574en-USSun, 27 May 2012 07:34:22 GMTSun, 27 May 2012 07:34:22 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorSat, 17 Mar 2007 04:41:17 GMT
And I subscribed just to read the rest of this???? My mistake! I read the first couple of paragraphs as a visitor and thought it might actually go somewhere so I subscribed ... turns out it’s a very basic rehash of info that’s readily available in a dozen other places. If this is what’s on offer ... UNSUBSCRIBE ME]]>MatthewSat, 17 Mar 2007 04:41:17 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorWed, 06 Jul 2005 08:23:24 GMT
**** it]]>Anonymous User Wed, 06 Jul 2005 08:23:24 GMThttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorThu, 23 Jun 2005 08:34:28 GMT
In order to search and highlight you’ll need to do what I did, and build your own routine to generate inflectional forms and word variants to pass to Microsoft Search - you’d be surprised how easy it is to produce better results than the native search engine using 3 relatively simple algorithms including Soundex, Levenstine and Porter’s Stemmer.]]>Anonymous User Thu, 23 Jun 2005 08:34:28 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorThu, 23 Jun 2005 08:30:14 GMT
Unfortunately, the SQL search is extremely limited. Plus, its ability to generate "word variants" is laughable - I ended up writing my own routines to produce a SQL string to send through. Surely a company like Microsoft can do better than this...]]>Anonymous User Thu, 23 Jun 2005 08:30:14 GMThttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorMon, 28 Feb 2005 15:18:46 GMT
This is one of the greatest articles for learning about something, that I have read. Its clear and easy to understand, wish more tutorials were like this one. Keep it up!]]>Anonymous User Mon, 28 Feb 2005 15:18:46 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorTue, 11 Jan 2005 11:04:03 GMT
I want to highlight all occurrences of the search within a document - is there a way to read through the text and highlight each occurrence of the search string?]]>Anonymous User Tue, 11 Jan 2005 11:04:03 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorWed, 13 Oct 2004 15:39:26 GMT
I found this article ery useful. I am very interested in using this type of search.]]>Anonymous User Wed, 13 Oct 2004 15:39:26 GMThttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorTue, 13 Apr 2004 01:37:34 GMT
what about searching for An Arabic Word for examble "ãÍãÏ" i found an error using Full text search in searching for it]]>mohamed alii Tue, 13 Apr 2004 01:37:34 GMThttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorTue, 13 Apr 2004 01:37:34 GMT
what about searching for An Arabic Word for examble "ãÍãÏ" i found an error using Full text search in searching for it]]>mohamed alii Tue, 13 Apr 2004 01:37:34 GMThttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorTue, 13 Apr 2004 01:37:34 GMT
what about searching for An Arabic Word for examble "ãÍãÏ" i found an error using Full text search in searching for it]]>mohamed alii Tue, 13 Apr 2004 01:37:34 GMThttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorFri, 05 Mar 2004 16:49:55 GMT
In the article does not mention that SQL Server Fulltext could be not "great, "greatest" and greater". The article need to considerate there are another implication before to create a fulltext index search as well as the process to update, delete, insert and make changes to the database “table or tables”. The use of FREETEXT, my personal experiences such as "search engine" are difficult. SQL Server take to long to update the data such as added, deleted or updating. In addition, if you have clients that they are depending to update their own data every day, you may have to considerer to find another options. By Victor Unda Undaconsulting.com]]>Victor Unda Fri, 05 Mar 2004 16:49:55 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorThu, 19 Feb 2004 23:03:59 GMT
Good and Excellent article. Special Thanks for Mr. David Jones for providing this wonderfull article.]]>Kannadasan Thu, 19 Feb 2004 23:03:59 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorThu, 19 Feb 2004 08:18:10 GMT
Great Stuff, Exactly what I was looking for. Thanks a lot!]]>Ramiro A. C. Souto Thu, 19 Feb 2004 08:18:10 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorTue, 02 Apr 2002 11:37:31 GMT
Interesting article but are there any significant differences when using SQL2000. Is there an up-to-date article specifically on sql2000 & full text search]]>Sanjeev Sharma Tue, 02 Apr 2002 11:37:31 GMThttp://www.windowsitpro.com/article/tsql3/build-a-better-search-engine#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchorThu, 25 Oct 2001 07:37:22 GMT
Hi, The article is fabulous. I have tried a similar approach but I am getting the following error: Server: Msg 7607, Level 17, State 1, Line 1 Search on full-text catalog ’Cat_Helpdesk_Bombay’ for database ID 14, table ID 357576312 with search condition ’"partner"’ failed with unknown result Would you please help me.. Regards, Fazal (341ff930).]]>Fazalhusein Z Patvi Thu, 25 Oct 2001 07:37:22 GMThttp://www.windowsitpro.com/article/sql-server-70/sample-full-text-search-engine#commentsAnchor