|
Text Search IGNORING Certain Characters
I'm not sure that "sqlserver.fulltext" is the right group for this posting.
I have a table with 3 unicode text columns, English, Hebrew, and Farsi
respectively. I want to write a query where the WHERE clause does a "... like
'%%'..." on each of those columns.
Here's my problem: Those columns h ...
Sat, 1 Jan 2005 09:55:10 -0800
|
Full-text setup error
Hi,
I'm trying to install full-text search service on SQL server using command
ftsetup.exe, but I always get error "FulltextSetup returned error code:
0x80000023".
I've upgraded MSDE with SQL Server 2000 standard . Upgrade process did not
install full-text search service, so I had to do it manually as i ...
Thu, 30 Dec 2004 15:16:25 +0100
|
Full-text search trouble
Hello , all
I try to run SELECT with contains function
select * from a
where (a.t , '"only*"')
but my query doesn't find any rows, it 's happened with the word - ONLY.
What's happening?
Thank you.
...
Thu, 23 Dec 2004 18:08:33 +0300
|
KB889708
Does anyone know if this affects when the FTS os on the second node to
incremental population?
Thxs. ...
Mon, 20 Dec 2004 09:07:03 -0800
|
Not getting any results back
Full text seach is working on my Development machine.
I created a similar full text search catelog on my test machine.But I am not
getting any results back.I chekced the event log..Every time it runs there
are four warnings which says
The message '-2147480624' for application 'Microsoft Search' could not be ...
Mon, 20 Dec 2004 08:25:03 -0800
|
Align text to the right
Hi
I'm trying to insert text values into another table, but I would like these
values to be aligned to the right. I wrote these lines I thought it would
fix the problem, but it didn't work:
INSERT INTO Employees (Number, Name)
VALUES (@Number, SPACE(150 - LEN(@Name)) + @Name)
Let's suppose the colu ...
Thu, 16 Dec 2004 13:13:26 -0600
|
Catalog Population Fails on Cluster
I have an installation that move their database to a cluster server.
SQL2000 has SP3 applied.
We created a new FTS against a single table, single row.
The table has 500,000 rows of data.
When I select "Start Full Population" the task completes immediately and the
count is one.
The edited text from the A ...
Thu, 16 Dec 2004 09:52:46 -0500
|
Population running for extended period
I have a job the runs nightly that does a brute force "exec
sp_fulltext_catalog @FtcName, 'start incremental'" on all customer
databases and all FTC.
I noticed that for a few days in a row that in specific databases there
are several FTC that always have a status of either "incremental
population in progress ...
15 Dec 2004 09:40:54 -0800
|
Search Mutlple Tables
Can I search(one query) against columns from two tables.Please share a basic
example.How does the ranking work in this case. ...
Wed, 15 Dec 2004 08:53:09 -0800
|
Sql Server 2005 (beta2) API
Maybe someone knows if this is possible...
I managed to get the Thesaurus working for full text searching, which
required me to restart the msftesql service.
So my question, is there a programable way to restart the service within the
Sql Server API namespaces? If so, any ideas as to which class? Also, ...
Wed, 15 Dec 2004 07:35:03 -0800
|
After restore database, what happy with full-text catelogs?
Hi,
I have CRM database that contains full-text catalogs. Someone delete rows by
mistake. I need restore this database to same server from last night backup,
after database restore, do I need manually active full-text indexes or it
will automatically enable since I restore database at same server?
If ...
Tue, 14 Dec 2004 09:31:07 -0800
|
Full-text query failed because full-text catalog 'SIMCatalog' is not yet ready for queries.
I have a server (W2k3) in wich i use arabic, french and english fulltext.
The arabic and french fulltext are correct but the english fulltext query
shows the following error :
Full-text query failed because full-text catalog 'SIMCatalog' is not yet
ready for queries.
Nb : SIMCatalog is my catalog ful ...
Mon, 29 Nov 2004 17:34:28 +0100
|
error 7623
Error 7623 - Full-text query failed because full-text catalog '%ls' is not
yet ready for
...
Wed, 24 Nov 2004 16:45:25 +0100
|
How to search for Keywords? Thank You.
Hello,
I have full text in a MS SQL database table.
I also have a string "Search" which contains all the keywords passed in
the URL to the page.aspx. I want to use the keywords.
What I have now is this:
SELECT *
FROM dbo.documents
WHERE CONTAINS (*, '"ASP*" or "BOOK*"')
Of course this only looks only ...
Fri, 10 Dec 2004 20:04:56 +0000
|
2005 fti query performance issue
I have a 10 million row table with two columns(name, address) full text
indexed. I want to search the table for
the first 200 occurances of "Bob jones" in the name field. I have ran
another query to find out that there are actully 15,291 rows with "Bob Jones"
in the name field. I want just the first 200.
W ...
Thu, 9 Dec 2004 08:03:02 -0800
|