|
Incremental population stops
Hi,
I've got what I believe to be an unusual situation. One of our clients is
reporting that they need to randomly restart the MSSearch service. They
detect this need by noticing that recent data (anywhere from 5 minutes to 5
hours) is not being found when they performa a search. However, the search
i ...
Mon, 4 Oct 2004 11:29:50 -0500
|
Searches are case sensitive?
I'm using a Freetexttable search as in the following:
SELECT blah from Table1
INNER JOIN (FREETEXTTABLE(Tabl1, keywords, ''' + @Query + ''') AS RANKTBL1
When a user types in xp for the query, it returns different results than XP in caps.
Can someone explain this to me and is there a way to stop it?
...
4 Oct 2004 08:38:36 -0700
|
Change buffer size for the text datafile data
When populating a table with a column of TEXT datatype, an error
message was shown, indicating that the data is too large for the
specified buffer size. How we I change the buffer size from the SQL
Server Enterprise Manager?
TIA,
Jeffrey ...
1 Oct 2004 15:23:29 -0700
|
Installing SQLServer EE for full text searching
Hi there,
Does anyone know how I go about upgrading from SQL2000 standard edition to
SQL2000 enterprise edition (I need to install full-text searching). Is it as
easy as slamming in the enterprise edition CD and upgrading, or are there any
known issues?
Thanks
Cammie. ...
Thu, 30 Sep 2004 08:03:05 -0700
|
The Microsoft Search service cannot be administered under the present user accou
We have a problem with implementing Full-Text capability.
Here are the details about our system: We have:
1) Windows 2000 Server
2) Windows SQL-Server 2000 Server with SP3a
3) And Full-Text component installed while installing SQL-
Server 2000.
-- We installed SQL-Server 2000 with a user with admin
ri ...
Wed, 29 Sep 2004 00:17:11 -0700
|
Interesting - using Freetexttable and NEAR
Hilary, results do change when I use NEAR between words with Freetexttable.
In fact the returned set when I limit it to top 10 is quite different. I
think I can read into your statement below and sort of understand why the
difference. I need to take more time to look at my results and then check
them against th ...
Fri, 24 Sep 2004 10:40:11 -0500
|
NEAR operator
What is the specific function of NEAR?
I'm indexing across 3 text fields and expect hits for 'white NEAR black' and
only getting a hit when the two words are in the same field, but not if they
are spread across two of the fields.
How NEAR does the other word have to be?
...
Thu, 23 Sep 2004 16:27:59 -0500
|
Implementation of full text
Can someone share the details about implementation of full text search
functionliaty in the database. i.e, how are the functions/predicates
implemented.
I was trying out a ESP (Extended Stored Procs) programming and got stuck
with returning resultset from ESP and relaying the same as Table Function in
SQ ...
Thu, 23 Sep 2004 10:21:01 -0700
|
Incremental Population help...
Hello everyone,
First of all, my name is Hugo.
I'm having a very strange situation when performing an Incremental Population.
I have a Table "A" with a timestamp column, and a catalogue over three
columns of "A". This table has only 100K rows (a subset of our production
environment, with about 3 Million ...
Thu, 23 Sep 2004 04:13:02 -0700
|
SQL 2000 Full-Text Search requirement
Hi,
May i know what's the requirement to implement full-text search?
Do FTS run under Windows XP and Windows 2003 environment?
Thanks!
220 13107
From: "Yokino"
Subject: SQL 2000 Full-Text Search requirement
Date: Thu, 23 Sep 2004 15:36:42 +0800
...
Thu, 23 Sep 2004 15:36:42 +0800
|
OLE DB provider 'MSIDXS' reported an error. Access denied.
Not sure if I should post here of inetserver.indexserver, so I apologize
ahead of time.
In Sql2000, I've added a linked server to a development box.
EXEC sp_addlinkedserver Web,
'Index Server',
'MSIDXS',
'stjoedev01.CarenetWeb'
I ran the same command on my local Sql box.
When I execute thi ...
Mon, 20 Sep 2004 15:55:01 -0700
|
Rank Order
CREATE Table MyTable(
ID int,
Title varchar(1000)
)
I trying to find all records that contains any of the words :
"one," "two," or "three" in title column.
I need to order the result by row that contains most of the words.
Any help will be appreciated.
Thanks,
Rakesh
...
Mon, 20 Sep 2004 13:47:28 -0700
|
Incremental Fill of Full-Text Catalog Problem. Please help!
Hello everybody, and thanks in advance for your help.
Well, I have created a full-text index in a table with about one
million
records, indexing three fields.
To start with, I created it with an incremental filling programming
once
a week, saturday night.
But the problem is that without an apparent cause, ...
20 Sep 2004 01:06:01 -0700
|
Freetexttable
I am very new to the freetext searching and have not been
able to decipher some of the documentation steps in making
FreeTextTable work.
I have a table with a primary key of "KeyID", and my
search index is created on varchar fields of Problem and
Cause. I also have a field called WorkOrderID which is no ...
Fri, 17 Sep 2004 05:33:25 -0700
|
FTS: Search across film actors
'X-No-archive: yes'
Greetings:
I would like to use full-text searching to look over a series of
fields.
My stored procedure searches for film titles in a database.
The only problem I encounter is when I look in VideoPersonnel -- First
Name and Last Name columns. If my search is 'Alfred' or 'Hitchcock ...
15 Sep 2004 07:01:39 -0700
|