| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | People,
we are currently investigating, prototyping and comparing the architecture
of a full text search capability in a project. Our project has...
Remi Blanchette
|
08-23-2011 07:26 AM
pauliom  | 2 | 637 |
 | | 2011-01-14 12:00:09.80 spid17s Error '0x80cb4204' occurred during
full-text index population for table or indexed view '.
.ME_DOCS]' (table or...
malexanderjr
|
01-14-2011 11:47 AM
malexanderjr | 0 | 54 |
| | | Hi,
I am trying to implement search functionality in my web application which
does not return the expected results in accent insensitive...
Holysmoke
|
10-16-2010 06:17 AM
RS Emenu | 7 | 629 |
| | | Msg 9937, Level 16, State 5, Line 1
Too many full-text columns or the full-text query is too complex to be
executed.
HI
When I search for that in...
=?Utf-8?B?T0xBUEZPUkVWRVI=?=
|
10-01-2010 04:21 AM
Svend Tang | 13 | 301 |
| | | I want to use the Full Text Search feature of Microsoft SQL Server.
If I have a table Client which refers other tables like City,...
pevgeniev
|
08-15-2010 08:29 AM
pevgeniev | 0 | 54 |
| | | Hello,
I would like to know if any language component exists for the Albanian
language. I am searching especially for the stemmer in this...
eve eve
|
07-14-2010 05:48 AM
eve eve | 0 | 56 |
| | | Hi Friends,
SQL 2008
I need to be able to script the creating a full text index, in order
to make it part of my deploy process to production.
When I...
Pat.Rick
|
07-12-2010 02:00 PM
Pat.Rick | 0 | 52 |
| | | SQL SERVER 2008
I would like my Text to be stemmed (Stemming) first before Indexing.
I am interested in occurrence_count define...
Fahim Sunesra
|
07-06-2010 03:10 AM
Fahim Sunesra | 0 | 1,044 |
| | | Can somebody help?
I can't get fulltext to run - the following statement returns Null:
SELECT FT_Text FROM dbo.FTTestTable WHERE CONTAINS(FT_Text,...
Heinz-Dieter Janzen
|
07-01-2010 10:52 AM
Heinz-Dieter Janzen | 0 | 377 |
| | | The gorgeous new limited edition colour collection from GHD is on the
market ! This collection is designed for all hair-lengths. The lowwest
price...
ghdfans2010
|
06-07-2010 08:52 PM
ghdfans2010 | 0 | 405 |
| | | I have a database with somewhere around 4 million records with some
big text fields in it.
Currently the fulltext catalog size is about 800...
AntonieB
|
05-19-2010 03:59 PM
Arian | 1 | 610 |
| | | Hello there
How can i repair this?
Roy Goldhammer
|
05-19-2010 10:30 AM
Russell Fields | 1 | 353 |
| | | Hi,
I am using the June CTP release of SQL Server 2005 on Windows Sever 2003.
Is there a quick way to get a total natch count (estimate is OK)
of a...
Wenbin Zhang
|
04-20-2010 10:58 PM
Baz | 2 | 706 |
| | | Hi
Since I've installed SP3 on my SQL Server 2005 Database, I experience
sometimes very high CPU rates on some queries using full-text search.
It's...
yuan
|
04-15-2010 05:41 PM
yuan | 0 | 324 |
| | | Hello
I want to set a minimum word length on a Full Text Catalog to a value lower
than the default setting. Is this possible to do? When I look...
SQLSQUIRREL
|
04-12-2010 05:12 AM
Dan | 1 | 368 |
| | | Hi, does anyone know if it's possible to do a thesaurus search
together with NEAR or AND keywords.
Here is an example of the type of query I want to...
Enoch
|
03-30-2010 09:14 AM
Enoch | 0 | 348 |
| | | Hello everyone !
I am using SQL Server 2005 and the index for full text search consists of 5
fields.
While there is everything fine searching only...
Mats
|
03-24-2010 09:07 AM
Dan | 1 | 546 |
| | | To Whom It May Concern:
My name is Al Battle and I'm a Senior Software Engineer with eComSystems.
I'm working on a project which includes the usage...
AB
|
03-02-2010 01:10 PM
AB | 0 | 474 |
| | | Many problems with performance and safety of your computer can be solved
easily with an updated antivirus and recognized. Antivirus Free...
antivirus gratis
|
02-26-2010 10:46 AM
antivirus gratis | 0 | 350 |
| | | Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado...
antivirus gratis
|
02-17-2010 12:28 PM
antivirus gratis | 0 | 403 |
| | | hello,
I have the following problem. Everything was working fine
with the full text search. I created a catalog etc... now
in EM,...
Benoit
|
02-09-2010 08:12 AM
Mike Sowa | 8 | 647 |
| | | On sql 2k5 standard I need to be able to run a full text search for words
that contain wildcards. For instance prod name abc-123, which is...
Gigel
|
02-04-2010 08:14 AM
Gigel | 0 | 466 |
| | | 許多性能問題和安全性您的計算機*成惡意病毒，最好的辦法對付，這是得到承認和防病毒在計算機上安裝更新
...
antivirus gratis
|
02-02-2010 06:21 PM
antivirus gratis | 0 | 427 |
| | | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the...
Mia
|
02-01-2010 02:01 PM
Mia | 0 | 384 |
| | | Anyone has a list of COTS that compensate for SQL server FTS shortcomings?
Product that would run inside or outside of the SQL server instance are...
Remi Blanchette
|
01-29-2010 02:29 PM
Hilary Cotter | 1 | 477 |
| | | Hi,
I have a strange problem with fulltext search on sql server 2008.
When I export a simple report as .xls file from reporting services and
insert...
KN
|
01-26-2010 05:40 AM
KN | 0 | 330 |
| | | Apologies if this is a really basic thing - I read a couple books'
chapters on full text and didn't see it.
I have table A which has the event log...
M Bourgon
|
01-20-2010 01:48 PM
M Bourgon | 3 | 373 |
| | | I have a table with approximately 80,000 records. I've created a full text
index on the table with the following statement:
CREATE FULLTEXT INDEX...
Adam Winter
|
01-20-2010 12:59 PM
Adam Winter | 0 | 304 |
| | | Hi there,
I'm quite new to Full text, so I ran into a problem. I'm using SQL
Server 2005.
I've made a view over two tables, one with Document...
Marteki
|
01-16-2010 09:09 AM
Marteki | 0 | 328 |
| | | I have a query that in SQL 2008 will run 10 times slower then in SQL 2005.
Here is the query
SELECT DISTINCT(LEFT(ML.STUDENT_PROGRAMS_ID,7)) AS...
evan4434 via SQLMonster.com
|
01-12-2010 10:01 AM
evan4434 via SQLMonster.com | 0 | 320 |
| | | Hello,
I have the same problem exacly the same :(
I check the account service of SQL, MSSEARCH, and MS AGENT. Irs ok.
I dont know what going...
gabrielcz
|
12-30-2009 02:45 AM
Frank | 2 | 517 |
| | | I would like to search the words like O'Donnel, O'Connor,Steve's etc.. in the attachments. Tried to use ContainsTable and replaced the apostrophe...
Ramesh
|
12-23-2009 06:44 AM
hilary | 3 | 517 |
| | | Hello, i use sys.dm_fts_index_keywords_by_document to retrieve the
list of keyword for documents in a catalogue. DB preferences are
CI_AS; i create a...
salucci
|
12-21-2009 01:42 PM
Russell Fields | 5 | 515 |
| | | Hello,
I have an ASP.NET application and SQL Server 2008 Web backend. I use
full-text catalog for searching and I'm looking for some advices.
The...
Wojciech Kowasz
|
12-19-2009 07:13 AM
hilary | 3 | 467 |
| | | select FulltextCatalogProperty(N'houston', N'PopulateStatus')
Error: 942, Severity: 14, State: 4
The duration on this query is 12,530 ms. We have...
david pride
|
12-16-2009 07:55 AM
Hilary Cotter | 3 | 486 |
| | | Does anyone know how to calculate the size and storage requirements for a
fulltest index?
John Couch
|
12-09-2009 08:55 AM
Russell Fields | 1 | 459 |
| | | Hey let know u okay u can use this email if u need help thing then I will
chat email okay I will use the email cuz other so have email so plz...
yuri
|
12-08-2009 08:48 PM
yuri | 0 | 373 |
| | | Hi,
I have base with around 5 000 000 document and most of query are working
very fast but sometimes query are very long ???
This query take around 2...
jeanf
|
11-22-2009 01:31 PM
Hilary Cotter | 1 | 373 |
| | | Hi -
Um, I tried the code you gave as an example:
select * from FT_test where contains(theText, 'formsof(thesaurus, ''jog'')')
, and it didn't...
Steve M
|
11-20-2009 06:45 AM
Hilary Cotter | 3 | 445 |
| | | Hi -
I'm running SQL 2k5 Std Ed on Win XP Pro, current on SPs and patches.The
server collation is: SQL_Latin1_General_CP1_CI_AS
I tried to...
Steve M
|
11-19-2009 07:29 AM
Steve M | 2 | 346 |
| | | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on...
Mia
|
11-18-2009 07:23 AM
Mia | 0 | 337 |
| | | More than anything, its a generic interface to your data. Any data.
If it can be shown in a tabular format, we can work with it. (six
months of...
Mia
|
11-17-2009 09:08 AM
Mia | 0 | 402 |
| | | Hi all
Does anybody know something concerning about wordbreaker for Czech language?
Thanks a lot
Vlad
|
11-02-2009 02:11 PM
Boris Lehečka | 1 | 451 |
| | | Hello,
I did a fresh installation. Is the full text search by default installed?
If not, how can I tell if it is installed? Can I go back to...
tnt
|
10-28-2009 09:48 AM
Hilary Cotter | 2 | 412 |
| | | does anyone know if documents on which I want to have a full-text index need
to be in the database?
Is there a way to still have an index while the...
gvb
|
10-16-2009 10:31 AM
gvb | 3 | 411 |
| | | The first 1 or 2 times that I try to do a full text search (using CONTAINS(...
)), I get the following error:
An unhandled exception of type...
medbiller
|
10-15-2009 01:54 PM
medbiller | 0 | 360 |
| | | I enabled full text indexing on my database and on my table (sql Server
2005). My table has a unique index. Then I click on the Fulltext...
Rich
|
10-08-2009 10:19 AM
Howard Pierce-Morgan | 12 | 608 |
| | | Hi all,
I have ths problem: I would like to emulate the FTS feature inside a
C# application, without calling my SQL server DB.
That is, I simply...
cghersi
|
09-21-2009 05:34 AM
Vlad | 1 | 480 |
| | | Hi,
I use CONTAINSTABLE query and my target table includes the word 'we"as'
(with double quotes in the middle of the word).
I need to find the...
maxsee
|
09-16-2009 09:15 AM
maxsee | 2 | 558 |
| | | hi,
i'm having problem with querying thesaurus file that contains the characters
åäö. the tssve.xml file looks like this:
<XML ID="Microsoft...
Sarmad Aljazrawi
|
09-15-2009 02:55 AM
Sarmad Aljazrawi | 0 | 386 |
