all groups > sql server full text search > march 2004 > threads for march 22 - 28, 2004
Filter by week: 1 2 3 4 5
Searching a table
Posted by Sajid at 3/27/2004 2:37:25 AM
Hi all.
I have a requirement in which customer fills in a form.
The provided form fields are searched against the coulmns
in customer table. For example FirstName is searched
against FirstName in the table and so on. If the form data
is same as that of a table row than it is 100%. If for ... more >>
Full-Text Index Table option greyed out
Posted by Dan at 3/26/2004 11:54:21 AM
Hi
I have SQL Server 2000 running on a Windows XP platform.
I'm trying to add a full text index to one of the tables in my database.
However, I'm not sure if I've got this feature installed.
When I right-click on one of the tables, the "Full-Text Index Table" option
is greyed out.
sp_f... more >>
Full Text Search breaks after disc replaced
Posted by Jeff at 3/26/2004 12:52:06 AM
Hello,
(I also posted to the WSS newsgroup but remembered
somebody suggesting that this type of question might be
better answered in the sqlserver.fulltext newsgroup).
We recently had to replace our discs with larger ones. So
we ghosted the original disc containing the WSS dbase,
configur... more >>
help me get rid of the noise words please!
Posted by woodysapsucker at 3/25/2004 11:41:30 AM
Hi,
I am a programmer with no SQLServer dba experience and have set up a full
text index on two columns in the same table. The index is working fine
except for when a noise word is used in a search. My problem is that I have
been unable to remove the noise words. I have searched the drive and ... more >>
varchar(8000) versus text field?
Posted by bill at 3/24/2004 2:56:57 PM
Trying to decide if we should use large varchars or text fields for some
general notes type fields. We don't really need to do any extensive text
searching. A like query would probably be sufficient. The number of
records will be way < 100,000 and the app's relatively small at <50 users.
Wh... more >>
punctuation in fulltext searches
Posted by bmiller NO[at]SPAM tdpi.com at 3/24/2004 10:19:10 AM
I am using Fulltext search in a web application I wrote for our
company that is bascially a knowledge base search engine - the app
searches and returns matches against our SQL 2000 database. The
problem I am having is this:
I cannot seem to figure out how to search for phrases, booleans, and
... more >>
FTS Multiple partitioned tables
Posted by Prudhvi at 3/24/2004 1:51:08 AM
Hi
Help needed on Full text indexing multiple partitioned table
Let me explain u the actual scenario
I have a big Base Table that holds ntext columns(2columns) and other columns that are full text indexed to be used in FTS. This Base table grows every day with new data being inserted every day.... more >>
Add Category to SQL Full-text
Posted by derekvof NO[at]SPAM yahoo.com at 3/23/2004 1:10:44 PM
I'm moving my STS sites to WSS, and I'm running into a bit of a
problem. We've got everyone on our team adding a category to their
documents to help us search and organize them. However, seach under
WSS (w/ SQL and Free-Text search) doesn't pick up the category field
in my Word documents.
I s... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
FullText catalog item count is 0
Posted by Yiaz at 3/23/2004 9:16:06 AM
I've created a catalog against a fairly large table (around 900 rows) and selected Start full population from the catalogs context menu. A message appears saying it started populating successfully. However 24 hours later the Item count is still 0 and catalog size 1MB. I've tried restarting the FullT... more >>
hits highlight
Posted by Robert at 3/22/2004 4:09:24 PM
Hi,
I have an asp that perform a full text search against a sql server 2000.
Everything is working fine but i was wondering if it's possible to
highlight the search words of the hits , for example like google does.
Any idea how to do this?
Thanks in advance,
Robert.
... more >>
Full Text Search on XP Pro
Posted by John at 3/22/2004 12:46:09 PM
All
I have the Developer edition running on XP Pro. I "added" FTS as it was not done automatically during the regular installation. The box is checked when I run the installation CD and check the options that I can add
I cannot however get FTS to enable. When I try to access it under the Ente... more >>
SQL Server with Full Text Search and Enterprise Manager on stand alone machien
Posted by Mac Littlefield at 3/22/2004 10:51:11 AM
Hi,
Having discovered that MSDE doesn't support either Full Text Searches or
make available the Enterprise Manager Tool, I am looking for the least
expensive version of MS SQL Server that will support these two features on a
desktop running Windows XP.
Thanks,
Mac Littlefiele
... more >>
|