|
|
|
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 |
Full text indexing with Japanese characters problem Posted by ibiza at 3/31/2006 9:20:09 AM Hi all,
I am quite experimented with SQL Server, but not that much with full
text indexing. After some successful attempts with english fields, I've
decided to try it with Japanese characters. I don't know why, but it
seems to have a strange behaviour.
As in this screenshot
(http://img...more >>
One or more documents stored in image columns with extension 'doc' Posted by Victor at 3/30/2006 6:29:02 AM I keep receiving these on SQL server (2000, SP3a) that my SharePoint is using:
One or more documents stored in image columns with extension 'doc' did not
get full-text indexed because loading the filter failed with error '0x1'.
Note: These documents will not be passed to MSSearch for ...more >>
Noise Words Posted by s.cawood NO[at]SPAM gmail.com at 3/30/2006 3:06:39 AM We were getting errors when users searched for the term "r&d" - with or
without quotes - so we removed all single-letter words from the noise
word files (.eng, .enu and .dat). We then started Microsoft Search
again and did a full population - "rebuild" was grayed out.
This stopped the error but ...more >>
Steps to migrate FTS SQL 2000 to SQL 2005 side by side Posted by Pineda at 3/28/2006 8:30:03 AM Hi,
I am trying to upgrade side by side SQL 2000 to SQL 2005, one database
with FTS catalogs. I want always to have the SQL 2000 production server
online.
I have tried in one test environment to detach the SQL 2000 DB , but this
not work because when I tried to reattached the DB on SQL ...more >>
Multilingual content indexing Posted by Radrizzi Gilles at 3/24/2006 6:58:02 AM Hi there,
We have a Windows Sharepoint Services installation and are indexing its
content. I have a question regarding the index so I thought it might be
better to post here instead of the WSS newsgroups.
Anyway, here we go:
We have thousands of documents with content in multiple langauges ...more >>
Full text search alternative without leading wildcard limitation Posted by google NO[at]SPAM macrotex.net at 3/24/2006 6:32:06 AM As has been mentioned several times in this group, SQL Server does not
support a leading wildcard in full text searches (i.e., CONTAINS(field,
'*tion')).
To get around this I have been looking at external full text search
engines that might not have this restriction but with little success:
m...more >>
SQL Server 2005 Full Text Problem Posted by Joris De Groote at 3/23/2006 12:00:00 AM Hi,
I'm trying to use a SQL Server 2005 with WSS (Sharepoint Services). I try to
index the files in the WSS however this just doesn't work. I have set the
full-text in Sharepoint & the service in SQL Server 2k5 is installed and
running.
I have this working in SQL Server 2k, why isn't this wor...more >>
full text searching... Posted by Ollie Riches at 3/22/2006 8:25:06 PM I am working on a system where we wish toc reat a full text catalog in =
sql server 2000. I created a test catalog and started a 'full =
population' but it failed. After several attempts I restarted the =
'Mircosoft Search' service and it is failing with the following error:
"The Gatherer prop...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Full-Text Search Not Finding Suffix Posted by Karina at 3/22/2006 12:36:31 PM Hello,
This is my first post to MS tech net. I started using SQL Server 2005 and
Visual Studio 2005 YESTERDAY so I am very new to this.
I am implementing a site search and want to use Full-Text search. I have a
small test table with a few columns (all enabled for FTS and I have populat...more >>
Full-text Search, Query returns empty Posted by Sherry at 3/20/2006 11:19:29 AM Hello,
I'm working on a project using SQL server 2000 full text search. My os is
windows XP professional. (And I also tried to remote
connect to a windows 2000 server computer to do the same thing.) The problem
is same: query returns empty rows.
I followed all the steps from msdn websi...more >>
FTS- not returning results when lines are searched. Posted by Varun at 3/20/2006 7:14:12 AM Hello everyone,
I am performing full-text-search on a table containing word documents
in it's column. The search results fair when a single word is
searched. i.e. when I fire the following query:
select * from docs where contains(document, '"java"');
but if I try to search the a full...more >>
How to delete full text catalog in SQL server 2005 Posted by shao at 3/15/2006 4:23:38 PM I copied a database. Then I need to delete full text catalog and
re-create one with exact same name. But it doesn't let me drop it. The
machine just hangs there forever when I try to drop it. So I read
through the usenet and found a way to delete it from
sysfulltextcatalogs in sql 2000. But in s...more >>
FTS in SQL2005 and JOINS Posted by johnsolver NO[at]SPAM gmail.com at 3/14/2006 4:29:16 AM Hi, I'm having a slight problem with some of my FTS queries, namely it
seems that in SQL 2005 the execution plans are constructed by first
doing the normal query and then joining with the FTS results.
For instance:
SELECT P.id,P.name
FROM CONTAINSTABLE(prd_Names,phrase,'"hp*"') F
INNER JOI...more >>
restricted indexing? Posted by soc at 3/14/2006 12:00:00 AM Hi,
Sorry if this is an FAQ...
I have a column of text and a bit column. Is there a recommended approach to
searching the text where the bit=1?
Thanks Soc.
...more >>
Ignored words in the full text query Posted by Griff at 3/13/2006 4:20:38 PM Got a bizarre problem
In our search box, someone types in the search term:
A$
This results in the PARTIAL SQL:
......AND (CONTAINS(TableToQuery, ' ""A$"" '))
And this results in the error:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation fai...more >>
Multi Column full-text search question Posted by dedi at 3/8/2006 6:28:26 PM I would like to select rows containing some text which is more than one word.
The problem is that the text can appear in different colums, meaning, one
word in this column and another in that. moreove, I need to select only the
rows containing all the words.
The fulltext search is on one t...more >>
problem in freetext search in MS SQL Server Posted by Mahesh at 3/8/2006 3:14:47 AM hi
i have problem in fulltex search, when i search any
english word it give me perfect result.
In my table i have define fulltext search on a column
name content_html, data type of column is ntext it
stores htlm content.
now when i search any unicode character(gujarati word)
it shows me...more >>
Full-text working sporadically Posted by KEY at 3/7/2006 10:00:36 AM I have full-text running on one database only. This index seems to have
issues about once every couple of weeks. Normally, a search can be done (via
webpage) on a keyword - and it works fine. But there are times that no
keyword (or other options) searches will work. The only option that is...more >>
Full-Text Index Table choice grayed out Posted by dw at 3/7/2006 8:58:02 AM Hi. I'm connecting to a database on SQL Server 2000 SP3 on which I'm the
dbo. However, when I right-click any of the tables, it has the "Full-Text
Index Table" item grayed out. Is this only available to members of the SA
group on the server? Thanks.
...more >>
Fulltext and text type fields Posted by tshad at 3/2/2006 4:01:51 PM Does Fulltext work on text fields?
I thought it didnt, but I just changed my varChar(8000) field to text and it
still seemed to work !
Thanks,
Tom
...more >>
full text indexing opening many connections Posted by Karel at 3/2/2006 7:47:27 AM i created a job that performs indexing. the execution time takes only a
second. i noticed, however, using SQL Profiler that the process opened 32
connections!
trace details....
EventClass: Audit Login
ApplicationName: PKM
NTUserName: System
LoginName: NT AUTHORITY\SYSTEM
this many...more >>
Setting noise words per-database Posted by Greg Smalter at 3/1/2006 5:20:27 PM On a single installation of SQL Server 2005, is it possible to have
individual databases use different noise word settings without some hack like
pretending that one database is US-English and another is British English?
I have a few databases I want to use a populated noise word list (which ...more >>
Need help to perform FTS on this table.. Posted by Varun at 3/1/2006 5:48:24 AM Hello all,
I am working on a project and need some help. I am having an
application that uploads the data in the "resume" table and the content
of resume table is as follows:
<pre>
rid fileName docType resume_Title
document
1 ANewFile.doc doc ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |