|
|
|
Boolean queries not working over the all columns in the index
Thu, 10 Jul 2008 04:06:00 -0700
If I execute a query such as this one, I get back records that contain
"DaVinci" in AddressLine1 column and "Kirkland" in the City column:
select ft.id, ft.name, Line1, Line2, Line3, line4, city, county
from company as ft
inner join containstable(company, * , '"barnes nobl*"') as [key]
on ft.id = [key].[key] ...
|
There is no enough storage space available... error
Tue, 8 Jul 2008 16:08:45 +0200
Hi friends, and sorry for my english.
I have a SQL Server 2000 with severals databases which hold more than 210
full text catalogs.
Recently, after create the last 3 DBs with 10 catalogs each, when the
Mssearch service populates the catalogs, I am getting the following error in
the application viewer: "C ...
|
Full text catalog does not get associated with the specified FileG
Thu, 3 Jul 2008 22:05:00 -0700
Hi
I am trying to create a full text catalog on sql server 2008 feb CTP. The
create command executes successfully, however, the catalog does not get
associated with the filegroup specified in the create command. Trying to open
properties of the catalog results in error that filegroup property is not
avail ...
|
The Gatherer object in project <SQLServer SQLxxxxxxx>cannot be
initialized. Error:0 - The operation complete successfully
Wed, 2 Jul 2008 05:57:12 -0700 (PDT)
Hi Team,
Configuration:
SQL Server 2000 SP4
Clustered - Active / Passive
Windows 2000 SP4
Issue:
Full Text is not working when there is a cluster failover to the
passive node2 from active node1. When the cluster is again switched
back to the original node1, full text search is working properly!
Error ...
|
Help needed with SELECT query
Wed, 2 Jul 2008 11:45:54 +0200
Hi,
Don't know if this is the right forum...
Anyways I need some help with constructing a SELECT query:
The table below is an example:
WONUMBER PARENT AMOUNT HASCHILDREN
===========================================
1234 NULL 10 Y
2345 ...
|
??????View????????????
Wed, 2 Jul 2008 09:13:31 +0800
Dears£¬
²»ÖªµÀÊÇ·ñ¿ÉÒÔ¶ÔView½¨Á¢È«ÎļìË÷Ë÷Òý£¿
Èç¹û¿ÉÒÔ£¬Ôõô½¨Á¢£¿
лл¸÷λ´óÏÀ£¡
--
Best regards,
YuQ
...
|
Retrieving words found in text
Mon, 30 Jun 2008 11:12:01 -0700
Hi,
Is there a way to get a list (programmatically) of the words that SQL Server
expands a userâ??s search word to for inflectional search?
Example:
1. User searches â??runâ?
2. Inflectional search finds a document with the word â??ranâ? (different tense)
3. I want to display the word that was actual f ...
|
|
|
ft index stats: token frequency, etc ?
Mon, 30 Jun 2008 08:58:01 -0700
Hi -
I have looked in help, but was wondering if someone has some ~specific tips
on querying the ft index files themselves to determine & report token
frequency and other related ad hoc stats. I'd like to be able to query the ft
indexes directly to build my own stats.
Any pointers to _detailed_ info on f ...
|
'"n*"' prefix search
Thu, 26 Jun 2008 00:19:00 -0700
Can you tell me why a prefix search like:
SELECT <column_list> FROM <table> WHERE CONTAINS(<column1>, '"n*"')
(<column1> is a "nvarchar")
returns not only records containing text beginning with "n", but also
numeric data?
For example, this search will return "Normandin Mercier Grande Champagne
Peraudier 750 ...
|
How to pass Column value to Contains or FreeText Functions in SQL
Mon, 23 Jun 2008 00:32:00 -0700
Hi Folks,
I have a T-SQL query uses Contains,i have setup the index on my table,My
Question is: How can i pass column value to contains function in T-SQL,My
Query as follows:
SELECT Distinct
[KW].[displayName]
,[KW].[title]
,[KW].[mail]
,[SG].[mail]
FROM dbo.Table1 AS KW L ...
|
|
|
