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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|