|
|
|
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 |
Filter by week: 1 2 3 4 5 full text service not staring in Cluster environment! help! Posted by james at 8/6/2003 5:14:46 PM Hi! Recently I installed Sql server 2000 on Windows 2000 Cluster
environment. Everything seems to be working fine except Full text service
won't start in both nodes. In the application log the error is:
Eventid: 10006
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 10006
D...more >>
FTS slows down everything Posted by Pete at 8/6/2003 4:18:10 PM Thank Hilary and John, I am finally able to run
"exec sp_fulltext_database ..." on the server. There was
some log on mismatch between the Microsoft Search and SQL
Server.
Now that the FTS search is running on the server, I notice
that everything is slowed down severely on the server. I
...more >>
Search on "t.a.t.u." gets error "The query contained only ignored words" Posted by gary NO[at]SPAM webguild.com at 8/6/2003 12:39:23 PM This error occurs when searching for something like "t.a.t.u" on our
Windows Server 2003 SQL Server but not on our Win2K SQL Server. It
looks like (on 2003) the word is broken by the dots into 4 1-letter
words, one of which (a) is a noise word.
SELECT * FROM table WHERE CONTAINS(*, '"t.a.t.u."...more >>
FTS on disk files ? Posted by Harman at 8/6/2003 8:47:08 AM We want to index and search a large repository of data
that resides on disk. Can we index this data without
moving it into a database? I know Oracle UltraSearch
allows you to index file system data and creates the index
in a database. Just wondering if SQL Svr has anything
similar.
than...more >>
limiting results return by FTS? Posted by Hung Huynh at 8/5/2003 2:41:31 PM Is there a way to restrict the number of results returned from FTS query,
i.e.: TOP 1000?
Thanks!
HH
...more >>
Documents occasionally not indexed Posted by dschles NO[at]SPAM earthlink.net at 8/5/2003 10:47:21 AM We appear to have an issue with full-text search where occasionally a
document appears to not make it into our catalog. If we run queries
against our indexes they always return reasonable results, but every
so often a document that we know exists and should be in the result
set does not appear. ...more >>
firehose mode?? Posted by Robert Orlini at 8/4/2003 10:48:21 AM Why do I get this strange error when I try to add text to
a column in SQL while in open table mode?
"Transaction cannot start while in firehose mode"
I'm adding text to a nvarchar column with 255 chars.
Thanks.
Robert O.
...more >>
distinct Posted by jbrn100 NO[at]SPAM hotmail.com at 8/4/2003 2:57:24 AM Hi All,
i have a simple query:
select distinct(id) from bibl where contains( title, '"Term*"')
the results start with..:
A100200
A100200
A107434
A107435
I was hoping the distinct keyword would eliminate one 'A100200' result.
Does distinct not work on fts queries ?? I one have one...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
multiple language support on full-text search Posted by ming at 8/1/2003 9:14:00 AM Hi, based on my understanding, full-text search does
not support multiple languages seach in one database.
For example, if I have a table like this:
text_value(ntext), lang(varchar2)
----------------- --------------
'this is in English' 'US'
'this is in Japanes...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |