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 > 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 >>



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 >>


DevelopmentNow Blog