Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server full text search > february 2004 > threads for february 1 - 7, 2004

Filter by week: 1 2 3 4

Specifying different Noise.dat files, is this possible?
Posted by obhayes NO[at]SPAM hotmail.com at 2/6/2004 8:14:34 AM
Hi, Is there anyway to use a different set of noise.dat files for different full text catalogues? I am using SQL Server 2000 sp 2. E.g. I have a project (project 1) where I would like to remove the numbers from the noise word lists, however if I have another project installed (project 2) on...more >>


Single letter search
Posted by takiss at 2/6/2004 2:56:06 AM
Hi, could you please put me on the right track!? Right, the problem is: I run a query (using CONTAINS) on an indexed SQL Server 2k databse table. I need to allow my client to search on phrases containing single letters i.e "Mel B", "Mel C". The query results I get show that the search is ignorin...more >>

Problem indexing PDF files with Adobe IFilter 5.0 via Webdav
Posted by ardraug NO[at]SPAM hotmail.com at 2/6/2004 1:20:29 AM
Hello, I´m developing an application in ASP/ASPX, with: - MS Windows 2000 Server (All updates until this date are applied). - IIS 5.0 - SQL Server 2000 (SP3) - Adobe PDF IFilter v5.0 When I send a PDF file via http to database, file is indexed inmediately, with independence of the...more >>

Duration of Catalog Population
Posted by RGondzur at 2/5/2004 4:21:51 PM
I would like to gather info on how long it takes the catalog population to complete. Any ideas on how to retrieve this data? Thanks, Rg ...more >>

Indexing and Ecryption
Posted by dario at 2/5/2004 12:56:08 PM
On a SQL database, can indexing be performed while specific tables are encrypted Thanks...more >>

Return Column Name
Posted by ChuckCraig at 2/5/2004 8:16:06 AM
I have to FTS 50+columns across 3 joined tables. The search returns the appropriate result-set, however I need to know which columns contained the search criteria. So while my Select will have 50+ columns I need to idntify which casused them to be returns. We're using Microsoft SQL Server 2...more >>

word breaking problem with "e-term" expr
Posted by Calagurris2001 at 2/5/2004 3:31:06 AM
SELECT @@versio SELECT @@languag Microsoft SQL Server 2000 - 8.00760 (Intel X86).. us_englis I like to search a modern terms like 'e-business' 'e-commerce' and in spanish 'e-salud', 'e-administracion'.... but SQL Server make the word breaking with this terms and if you search e-business yo...more >>

querying the index server
Posted by jojo manikx at 2/5/2004 2:40:08 AM
how do i search the index server from the query analyzer of from sql server 2000. are there any configuration that i need to do to sql server 2000 and index server...more >>



wss full text index
Posted by Konrad Brunner at 2/4/2004 6:34:13 PM
Does someone out there could give me a starting point how to access the WSS full text index with asp.net ...more >>

FTS Search Question
Posted by goku24_dc NO[at]SPAM yahoo.com at 2/4/2004 1:03:20 PM
I am using FTS with the CONTAINSTABLE predicate, on a Win2K/MSSQL2K box. What I want to do is: If a user enters more than one word with no "" or boolean operators, treat the entire string as an OR statement. This is with maintaining the functionality of CONTAINSTABLE. So if I as a user p...more >>

Slash and Contains
Posted by Chris Buda at 2/4/2004 8:24:34 AM
When I query SQLServer FT Index using CONTAINS clause for a value that contains a "/" I get unexpected results. For example when performing a search for a product number "WIR 3/0THHN" I also get products "WIR 2/0THHN" and "WIR 4/0THHN" in the results of the search. Can anyone suggest a ...more >>

Win2003, MSSearch does NOT start
Posted by Sunil Kadimdiwan at 2/4/2004 7:36:06 AM
I just installed (new install) Win2003 Standard Server edition. Installed SQLServer 2000 with SP3. I am unable to start the MSSearch service. Error I get: Faulting application mssearch.exe, version 10.145.3914.3, faulting module mssearch.exe, version 10.145.3914.3, fault address 0x0000417c...more >>

full text search
Posted by krishna at 2/3/2004 3:56:36 AM
i am using full text indexing on sql server 2000. indexed one column "path" of the table "data" where the column "path" contains the path of some word documents. Whether it is possible for me to search the content of the corresponding document by taking only the path from "path" column?? ...more >>

How can CONTAINS be slower than LIKE !!
Posted by Andy Gilman at 2/2/2004 1:58:42 PM
I have a table with 300k+ entries containing job titles I have a full text index on this field. The query is SELECT COUNT(*) FROM JobTitles WHERE CONTAINS (JobTitle , ' "Developer" OR "Programmer" OR "SOFTWARE ENGINEER" ') -- whitespace added for readability and this returns 66229 e...more >>

Full Text Indexing Failing with strange error
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 2/2/2004 11:51:09 AM
Anyone ever encounter this error during full text indexing a table with MS Word 97 docs in it? The docs are stored in image fields. Error fetching URL, (80041201 - The object was not found. ) Most importantly, we're not using Sharepoint so please do not refer us to the MS doc on tha...more >>

Search more than one cloumn
Posted by Hank at 2/1/2004 8:11:07 PM
Hi, I have fulltext indexed several columns in a table, how do I search two or more columns but not all the columns? Thanks...more >>


DevelopmentNow Blog