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 8 - 14, 2004

Filter by week: 1 2 3 4

sql full text asp .net
Posted by Duy Nguyen at 2/13/2004 12:01:10 PM
I don't know if I should post here or aspnet community. If you know an answer to this, I'll be much appreciated. (SQl Server) I created a table for full-text search. It has an image field to store my html files and a field for extensions. However, when I retrieve data from SQL Server, I don'...more >>


Full Text Catalog Not Populating
Posted by arthur at 2/12/2004 2:41:09 PM
Microsoft SQL Server 7.00 - 7.00.961 (Intel X86) Oct 24 2000 18:39:12 Copyright (c) 1988-1998 Microsoft Corporatio Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2 I'm having trouble populating a full text catalog. Everytime I start population, item count is 0 and there are "c...more >>

Di-sect the Output/results
Posted by drmcl NO[at]SPAM drmcl.free-online.co.uk at 2/12/2004 6:40:20 AM
The answer to this may quite simply be no, but I would like to find the actual word lists that FTS produces and thus stores as the output from the population process as part of fts. My thinking is that by definition FTS must interrogate each column that is to be included and determine what each ...more >>

copying database causes FullText to not work
Posted by Uyen Nguyen at 2/11/2004 4:41:00 PM
I have imported another database onto my existing SQL 2000 database and found that my Full Text no longer works. Even though I have rebuild the catalog, whenever a full text query is run no result displays. Why is that? What do I need to do in order to have Full Text work? *** Sent vi...more >>

sql reporting services
Posted by christie at 2/11/2004 8:24:22 AM
Does the new reporting services require that you add users on the back end or do you create the requirements at the time you create the report?...more >>

CONTAIN
Posted by Uyen Nguyen at 2/10/2004 4:31:41 PM
I performed the following search using MS Query Analyzer (SQL 2000): select * from kc_rawtext where contains (value,'"Account"') however, all of my search always comes up empty/no result. Is CONTAIN working in SQL 2000? When I try the same type of search using LIKE, it works: select * f...more >>

Catalog Population Log
Posted by RGondzur at 2/10/2004 12:20:12 PM
Are there any log entries made anywhere when the catalog population is executed? Thanks, Rg ...more >>

please help~
Posted by Utada P.W. SIU at 2/9/2004 5:13:28 PM
anyone know why sql server disabled my New full-text catalog? I am trying to create a new full-text catalog but when I Server--> database and right click the function "new full-text catalog" is disable y?? thx~~ ...more >>



Limit nr of rows in containstable
Posted by news.microsoft.com at 2/9/2004 9:31:20 AM
Hi FT guys, We're working on an application based on FT queries but we have a problem : The DB is about 1.500.000 record and when we make search with a generic keyword 'car*' by example (occurs 60000 times in the DB). the query takes about 4 minutes ! When we limit the nb of rows in the con...more >>

Interface not supported - Full Text Searching
Posted by anthonyh NO[at]SPAM mtservices.co.uk at 2/9/2004 4:20:07 AM
I have reposted this question because my machine crashed during submittion. If this question appears twice then sorry! My system is Windows XP Pro SQL Server 2000 - SP3 VS.NET 2003 I am trying to generate a full text index on a table but I am getting 'Interface not supported' errors al...more >>


DevelopmentNow Blog