Full text search giving incomplete results

I have WSS set up to use the SQL full text search, but it wasn't returning
full results (though it will return some.) When I tried the search against
the table directly, it still only returned 2 instances of the 5 actual
occourences of the word. Nothing special, just searching for a simple text
string Calabasas for example.
I've rebuilt the index (which only takes 1-2 minutes), but to no avail.
1) Is the indexing/catalog usually more accurate than this?
2) Is there a way for me to improve the accuracy of the index/catalog? I
don't mind if it takes more server resources, I need to be able to find all
occurances of a word when I search for it. I've rebuilt/repopulated the
catalog, deleted/recreated, but it's not improving.
3) If it is supposed to be more accurate, what is the best way for me to
"fix" the catalog? Do I have to completely re-install SQL?
There are no event log errors, and the server seems to be running fine
besides this problem.
Thanks in advance for any help.
1) yes, the recall is excellent. However, WSS Search procs might filter out
some of your hits if the ranking is low. A FreeText search is done which
normally is more fuzzy, so you really should be seeing all the results.
2) Is Calabasas in the title of the document and not in the body? This might
account for what you are seeing.
3) Re-installing probably won't help. Your best bet is to figure out why
your content doesn't index.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:B55BC9A9-AB95-45EE-9BB1-FE9957B40F1F@.microsoft.com...
> I have WSS set up to use the SQL full text search, but it wasn't returning
> full results (though it will return some.) When I tried the search
against
> the table directly, it still only returned 2 instances of the 5 actual
> occourences of the word. Nothing special, just searching for a simple
text
> string Calabasas for example.
> I've rebuilt the index (which only takes 1-2 minutes), but to no avail.
> 1) Is the indexing/catalog usually more accurate than this?
> 2) Is there a way for me to improve the accuracy of the index/catalog? I
> don't mind if it takes more server resources, I need to be able to find
all
> occurances of a word when I search for it. I've rebuilt/repopulated the
> catalog, deleted/recreated, but it's not improving.
> 3) If it is supposed to be more accurate, what is the best way for me to
> "fix" the catalog? Do I have to completely re-install SQL?
> There are no event log errors, and the server seems to be running fine
> besides this problem.
> Thanks in advance for any help.
>
|||1) I bypassed WSS and did a search directly in SQL, and I still got the same
results (2 out of 5 occourances)
2) All 5 instances off Calabasas are in the body of the posting. There
isn't a difference in structure of the different posts.
3) Any tips on how I should be troubleshooting content that doesn't index?
I've been online all day searching, and haven't found anything that speaks to
this. (most people with a problem are getting no results, not partial
results.) It's a win2k SP4 server running SQL 2K SP3.
Thanks for the quick response. They want this fixed by tomorrow AM, so I'm
trying everything I can.
"Hilary Cotter" wrote:

> 1) yes, the recall is excellent. However, WSS Search procs might filter out
> some of your hits if the ranking is low. A FreeText search is done which
> normally is more fuzzy, so you really should be seeing all the results.
> 2) Is Calabasas in the title of the document and not in the body? This might
> account for what you are seeing.
> 3) Re-installing probably won't help. Your best bet is to figure out why
> your content doesn't index.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:B55BC9A9-AB95-45EE-9BB1-FE9957B40F1F@.microsoft.com...
> against
> text
> all
>
>
|||Did you search using the procs or using a custom sql statement? How do you
know there are 5 occurrences in the documents? Did you use a like?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:59B1B6D3-26B8-4CE7-91FB-E89698A6E816@.microsoft.com...
> 1) I bypassed WSS and did a search directly in SQL, and I still got the
same
> results (2 out of 5 occourances)
> 2) All 5 instances off Calabasas are in the body of the posting. There
> isn't a difference in structure of the different posts.
> 3) Any tips on how I should be troubleshooting content that doesn't index?
> I've been online all day searching, and haven't found anything that speaks
to
> this. (most people with a problem are getting no results, not partial
> results.) It's a win2k SP4 server running SQL 2K SP3.
> Thanks for the quick response. They want this fixed by tomorrow AM, so
I'm[vbcol=seagreen]
> trying everything I can.
>
> "Hilary Cotter" wrote:
out[vbcol=seagreen]
might[vbcol=seagreen]
returning[vbcol=seagreen]
avail.[vbcol=seagreen]
I[vbcol=seagreen]
find[vbcol=seagreen]
the[vbcol=seagreen]
to[vbcol=seagreen]
|||For the catalog used freetexttable
yes ‘like’
I manually found 5 occurrences.
"Hilary Cotter" wrote:

> Did you search using the procs or using a custom sql statement? How do you
> know there are 5 occurrences in the documents? Did you use a like?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:59B1B6D3-26B8-4CE7-91FB-E89698A6E816@.microsoft.com...
> same
> to
> I'm
> out
> might
> returning
> avail.
> I
> find
> the
> to
>
>
|||Dan,
Can you post the exact SQL CONTAINS (or FREETEXT) query you are using along
with the exact (including surrounding punctuation characters) text in the
columns of your FT-enabled column? Could you also post the output of the
following SQL code?
use <your_database_name_here>
go
SELECT @.@.language
SELECT @.@.version
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go
As you're using SQL Server 2000 SP3 on Windows 2000 Server (Win2K), the
OS-supplied wordbreaker (infosoft.dll) when used with the US English
"Language for Word Breaker" and depending upon your query and actual text
not return the correct & expected results. See
http://groups.google.com/groups?q=langwrbk+infosoft for past discussions on
this OS-supplied wordbreaker issue.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:59B1B6D3-26B8-4CE7-91FB-E89698A6E816@.microsoft.com...
> 1) I bypassed WSS and did a search directly in SQL, and I still got the
same
> results (2 out of 5 occourances)
> 2) All 5 instances off Calabasas are in the body of the posting. There
> isn't a difference in structure of the different posts.
> 3) Any tips on how I should be troubleshooting content that doesn't index?
> I've been online all day searching, and haven't found anything that speaks
to
> this. (most people with a problem are getting no results, not partial
> results.) It's a win2k SP4 server running SQL 2K SP3.
> Thanks for the quick response. They want this fixed by tomorrow AM, so
I'm[vbcol=seagreen]
> trying everything I can.
>
> "Hilary Cotter" wrote:
out[vbcol=seagreen]
might[vbcol=seagreen]
returning[vbcol=seagreen]
avail.[vbcol=seagreen]
I[vbcol=seagreen]
find[vbcol=seagreen]
the[vbcol=seagreen]
to[vbcol=seagreen]
|||Supposedly WSS searches with this...
select *
from freetexttable(userdata,ntext2,'calabasas')
which returns 2 results
If I do this...
select *
from userdata
WHERE ntext2 LIKE'%calabasas%'
I get 5 results
I'm just searching the ntext2 column, but there are a lot of things in there
so I can't post it, but the searched for term is calabasas, and it's always
spelled the same way, in two cases it's all caps, and in both of those cases
it's followed by a comma (one instance is found, the other one isn't.)
Result from running query:
us_english
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 4)
5ix_STS_LION_1C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA04
dboDocsDocs_IdUnique11ix_STS_LION_1
dboListsLists_FullText21ix_STS_LION_1
dboUserDataUserData_FullText151ix_STS_LION_1
dboUserInfoUserInfo_FullText41ix_STS_LION_1
dbo1993058136DocsLeafName4NULLNULL1033
dbo1993058136DocsContent34Extension361033
dbo421576540Liststp_Title3NULLNULL1033
dbo421576540Liststp_Description27NULLNULL1033
dbo501576825UserDatanvarchar117NULLNULL1033
dbo501576825UserDatanvarchar218NULLNULL1033
dbo501576825UserDatanvarchar319NULLNULL1033
dbo501576825UserDatanvarchar420NULLNULL1033
dbo501576825UserDatanvarchar521NULLNULL1033
dbo501576825UserDatanvarchar622NULLNULL1033
dbo501576825UserDatanvarchar723NULLNULL1033
dbo501576825UserDatanvarchar824NULLNULL1033
dbo501576825UserDatanvarchar925NULLNULL1033
dbo501576825UserDatanvarchar1026NULLNULL1033
dbo501576825UserDatanvarchar1127NULLNULL1033
dbo501576825UserDatanvarchar1228NULLNULL1033
dbo501576825UserDatanvarchar1329NULLNULL1033
dbo501576825UserDatanvarchar1430NULLNULL1033
dbo501576825UserDatanvarchar1531NULLNULL1033
dbo501576825UserDatanvarchar1632NULLNULL1033
dbo501576825UserDatanvarchar1733NULLNULL1033
dbo501576825UserDatanvarchar1834NULLNULL1033
dbo501576825UserDatanvarchar1935NULLNULL1033
dbo501576825UserDatanvarchar2036NULLNULL1033
dbo501576825UserDatanvarchar2137NULLNULL1033
dbo501576825UserDatanvarchar2238NULLNULL1033
dbo501576825UserDatanvarchar2339NULLNULL1033
dbo501576825UserDatanvarchar2440NULLNULL1033
dbo501576825UserDatanvarchar2541NULLNULL1033
dbo501576825UserDatanvarchar2642NULLNULL1033
dbo501576825UserDatanvarchar2743NULLNULL1033
dbo501576825UserDatanvarchar2844NULLNULL1033
dbo501576825UserDatanvarchar2945NULLNULL1033
dbo501576825UserDatanvarchar3046NULLNULL1033
dbo501576825UserDatanvarchar3147NULLNULL1033
dbo501576825UserDatanvarchar3248NULLNULL1033
dbo501576825UserDatanvarchar3349NULLNULL1033
dbo501576825UserDatanvarchar3450NULLNULL1033
dbo501576825UserDatanvarchar3551NULLNULL1033
dbo501576825UserDatanvarchar3652NULLNULL1033
dbo501576825UserDatanvarchar3753NULLNULL1033
dbo501576825UserDatanvarchar3854NULLNULL1033
dbo501576825UserDatanvarchar3955NULLNULL1033
dbo501576825UserDatanvarchar4056NULLNULL1033
dbo501576825UserDatanvarchar4157NULLNULL1033
dbo501576825UserDatanvarchar4258NULLNULL1033
dbo501576825UserDatanvarchar4359NULLNULL1033
dbo501576825UserDatanvarchar4460NULLNULL1033
dbo501576825UserDatanvarchar4561NULLNULL1033
dbo501576825UserDatanvarchar4662NULLNULL1033
dbo501576825UserDatanvarchar4763NULLNULL1033
dbo501576825UserDatanvarchar4864NULLNULL1033
dbo501576825UserDatanvarchar4965NULLNULL1033
dbo501576825UserDatanvarchar5066NULLNULL1033
dbo501576825UserDatanvarchar5167NULLNULL1033
dbo501576825UserDatanvarchar5268NULLNULL1033
dbo501576825UserDatanvarchar5369NULLNULL1033
dbo501576825UserDatanvarchar5470NULLNULL1033
dbo501576825UserDatanvarchar5571NULLNULL1033
dbo501576825UserDatanvarchar5672NULLNULL1033
dbo501576825UserDatanvarchar5773NULLNULL1033
dbo501576825UserDatanvarchar5874NULLNULL1033
dbo501576825UserDatanvarchar5975NULLNULL1033
dbo501576825UserDatanvarchar6076NULLNULL1033
dbo501576825UserDatanvarchar6177NULLNULL1033
dbo501576825UserDatanvarchar6278NULLNULL1033
dbo501576825UserDatanvarchar6379NULLNULL1033
dbo501576825UserDatanvarchar6480NULLNULL1033
dbo501576825UserDatantext1162NULLNULL1033
dbo501576825UserDatantext2163NULLNULL1033
dbo501576825UserDatantext3164NULLNULL1033
dbo501576825UserDatantext4165NULLNULL1033
dbo501576825UserDatantext5166NULLNULL1033
dbo501576825UserDatantext6167NULLNULL1033
dbo501576825UserDatantext7168NULLNULL1033
dbo501576825UserDatantext8169NULLNULL1033
dbo501576825UserDatantext9170NULLNULL1033
dbo501576825UserDatantext10171NULLNULL1033
dbo501576825UserDatantext11172NULLNULL1033
dbo501576825UserDatantext12173NULLNULL1033
dbo501576825UserDatantext13174NULLNULL1033
dbo501576825UserDatantext14175NULLNULL1033
dbo501576825UserDatantext15176NULLNULL1033
dbo501576825UserDatantext16177NULLNULL1033
dbo501576825UserDatantext17178NULLNULL1033
dbo501576825UserDatantext18179NULLNULL1033
dbo501576825UserDatantext19180NULLNULL1033
dbo501576825UserDatantext20181NULLNULL1033
dbo501576825UserDatantext21182NULLNULL1033
dbo501576825UserDatantext22183NULLNULL1033
dbo501576825UserDatantext23184NULLNULL1033
dbo501576825UserDatantext24185NULLNULL1033
dbo501576825UserDatantext25186NULLNULL1033
dbo501576825UserDatantext26187NULLNULL1033
dbo501576825UserDatantext27188NULLNULL1033
dbo501576825UserDatantext28189NULLNULL1033
dbo501576825UserDatantext29190NULLNULL1033
dbo501576825UserDatantext30191NULLNULL1033
dbo501576825UserDatantext31192NULLNULL1033
dbo501576825UserDatantext32193NULLNULL1033
dbo981578535UserInfotp_Login8NULLNULL1033
dbo981578535UserInfotp_Title9NULLNULL1033
dbo981578535UserInfotp_Email10NULLNULL1033
UserDatadbouser table2004-12-22 12:33:26.100
tp_IDintno410 0 no(n/a)(n/a)NULL
tp_ListIduniqueidentifierno16 no(n/a)(n/a)NULL
tp_SiteIduniqueidentifierno16 no(n/a)(n/a)NULL
tp_Versionintno410 0 no(n/a)(n/a)NULL
tp_Authorintno410 0 yes(n/a)(n/a)NULL
tp_Editorintno410 0 yes(n/a)(n/a)NULL
tp_Modifieddatetimeno8 yes(n/a)(n/a)NULL
tp_Createddatetimeno8 yes(n/a)(n/a)NULL
tp_Orderingvarcharno512 yesnonoLatin1_General_CI_AS_KS_WS
tp_HasAttachmentbitno1 no(n/a)(n/a)NULL
tp_ModerationStatusintno410 0 no(n/a)(n/a)NULL
tp_IsCurrentbitno1 no(n/a)(n/a)NULL
tp_ItemOrderfloatno853 NULLyes(n/a)(n/a)NULL
tp_InstanceIDintno410 0 yes(n/a)(n/a)NULL
tp_GUIDuniqueidentifierno16 no(n/a)(n/a)NULL
tp_Sizeintno410 0 no(n/a)(n/a)NULL
nvarchar1nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar2nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar3nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar4nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar5nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar6nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar7nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar8nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar9nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar10nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar11nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar12nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar13nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar14nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar15nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar16nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar17nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar18nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar19nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar20nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar21nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar22nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar23nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar24nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar25nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar26nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar27nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar28nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar29nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar30nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar31nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar32nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar33nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar34nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar35nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar36nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar37nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar38nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar39nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar40nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar41nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar42nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar43nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar44nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar45nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar46nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar47nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar48nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar49nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar50nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar51nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar52nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar53nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar54nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar55nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar56nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar57nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar58nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar59nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar60nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar61nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar62nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar63nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
nvarchar64nvarcharno510
yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
int1intno410 0 yes(n/a)(n/a)NULL
int2intno410 0 yes(n/a)(n/a)NULL
int3intno410 0 yes(n/a)(n/a)NULL
int4intno410 0 yes(n/a)(n/a)NULL
int5intno410 0 yes(n/a)(n/a)NULL
int6intno410 0 yes(n/a)(n/a)NULL
int7intno410 0 yes(n/a)(n/a)NULL
int8intno410 0 yes(n/a)(n/a)NULL
int9intno410 0 yes(n/a)(n/a)NULL
int10intno410 0 yes(n/a)(n/a)NULL
int11intno410 0 yes(n/a)(n/a)NULL
int12intno410 0 yes(n/a)(n/a)NULL
int13intno410 0 yes(n/a)(n/a)NULL
int14intno410 0 yes(n/a)(n/a)NULL
int15intno410 0 yes(n/a)(n/a)NULL
int16intno410 0 yes(n/a)(n/a)NULL
float1floatno853 NULLyes(n/a)(n/a)NULL
float2floatno853 NULLyes(n/a)(n/a)NULL
float3floatno853 NULLyes(n/a)(n/a)NULL
float4floatno853 NULLyes(n/a)(n/a)NULL
float5floatno853 NULLyes(n/a)(n/a)NULL
float6floatno853 NULLyes(n/a)(n/a)NULL
float7floatno853 NULLyes(n/a)(n/a)NULL
float8floatno853 NULLyes(n/a)(n/a)NULL
float9floatno853 NULLyes(n/a)(n/a)NULL
float10floatno853 NULLyes(n/a)(n/a)NULL
float11floatno853 NULLyes(n/a)(n/a)NULL
float12floatno853 NULLyes(n/a)(n/a)NULL
float13floatno853 NULLyes(n/a)(n/a)NULL
float14floatno853 NULLyes(n/a)(n/a)NULL
float15floatno853 NULLyes(n/a)(n/a)NULL
float16floatno853 NULLyes(n/a)(n/a)NULL
float17floatno853 NULLyes(n/a)(n/a)NULL
float18floatno853 NULLyes(n/a)(n/a)NULL
float19floatno853 NULLyes(n/a)(n/a)NULL
float20floatno853 NULLyes(n/a)(n/a)NULL
float21floatno853 NULLyes(n/a)(n/a)NULL
float22floatno853 NULLyes(n/a)(n/a)NULL
float23floatno853 NULLyes(n/a)(n/a)NULL
float24floatno853 NULLyes(n/a)(n/a)NULL
float25floatno853 NULLyes(n/a)(n/a)NULL
float26floatno853 NULLyes(n/a)(n/a)NULL
float27floatno853 NULLyes(n/a)(n/a)NULL
float28floatno853 NULLyes(n/a)(n/a)NULL
float29floatno853 NULLyes(n/a)(n/a)NULL
float30floatno853 NULLyes(n/a)(n/a)NULL
float31floatno853 NULLyes(n/a)(n/a)NULL
float32floatno853 NULLyes(n/a)(n/a)NULL
datetime1datetimeno8 yes(n/a)(n/a)NULL
datetime2datetimeno8 yes(n/a)(n/a)NULL
datetime3datetimeno8 yes(n/a)(n/a)NULL
datetime4datetimeno8 yes(n/a)(n/a)NULL
datetime5datetimeno8 yes(n/a)(n/a)NULL
datetime6datetimeno8 yes(n/a)(n/a)NULL
datetime7datetimeno8 yes(n/a)(n/a)NULL
datetime8datetimeno8 yes(n/a)(n/a)NULL
datetime9datetimeno8 yes(n/a)(n/a)NULL
datetime10datetimeno8 yes(n/a)(n/a)NULL
datetime11datetimeno8 yes(n/a)(n/a)NULL
datetime12datetimeno8 yes(n/a)(n/a)NULL
datetime13datetimeno8 yes(n/a)(n/a)NULL
datetime14datetimeno8 yes(n/a)(n/a)NULL
datetime15datetimeno8 yes(n/a)(n/a)NULL
datetime16datetimeno8 yes(n/a)(n/a)NULL
bit1bitno1 yes(n/a)(n/a)NULL
bit2bitno1 yes(n/a)(n/a)NULL
bit3bitno1 yes(n/a)(n/a)NULL
bit4bitno1 yes(n/a)(n/a)NULL
bit5bitno1 yes(n/a)(n/a)NULL
bit6bitno1 yes(n/a)(n/a)NULL
bit7bitno1 yes(n/a)(n/a)NULL
bit8bitno1 yes(n/a)(n/a)NULL
bit9bitno1 yes(n/a)(n/a)NULL
bit10bitno1 yes(n/a)(n/a)NULL
bit11bitno1 yes(n/a)(n/a)NULL
bit12bitno1 yes(n/a)(n/a)NULL
bit13bitno1 yes(n/a)(n/a)NULL
bit14bitno1 yes(n/a)(n/a)NULL
bit15bitno1 yes(n/a)(n/a)NULL
bit16bitno1 yes(n/a)(n/a)NULL
uniqueidentifier1uniqueidentifierno16 yes(n/a)(n/a)NULL
ntext1ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext2ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext3ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext4ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext5ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext6ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext7ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext8ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext9ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext10ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext11ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext12ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext13ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext14ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext15ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext16ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext17ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext18ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext19ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext20ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext21ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext22ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext23ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext24ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext25ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext26ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext27ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext28ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext29ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext30ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext31ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
ntext32ntextno16 yes(n/a)(n/a)Latin1_General_CI_AS_KS_WS
sql_variant1sql_variantno8016 yesno(n/a)NULL
sql_variant2sql_variantno8016 yesno(n/a)NULL
sql_variant3sql_variantno8016 yesno(n/a)NULL
sql_variant4sql_variantno8016 yesno(n/a)NULL
sql_variant5sql_variantno8016 yesno(n/a)NULL
sql_variant6sql_variantno8016 yesno(n/a)NULL
sql_variant7sql_variantno8016 yesno(n/a)NULL
sql_variant8sql_variantno8016 yesno(n/a)NULL
No identity column defined.NULLNULLNULL
No rowguidcol column defined.
PRIMARY
UserData_FullTextnonclustered, unique located on PRIMARYtp_GUID
UserData_PKclustered, unique, primary key located on PRIMARYtp_ListId, tp_ID
DEFAULT on column
tp_GUIDDF__UserData__tp_GUI__22AA2996(n/a)(n/a)(n/a)(n/a)(newid())
DEFAULT on column
tp_HasAttachmentDF__UserData__tp_Has__1FCDBCEB(n/a)(n/a)(n/a)(n/a)(0)
DEFAULT on column
tp_IsCurrentDF__UserData__tp_IsC__21B6055D(n/a)(n/a)(n/a)(n/a)(1)
DEFAULT on column
tp_ModerationStatusDF__UserData__tp_Mod__20C1E124(n/a)(n/a)(n/a)(n/a)(0)
DEFAULT on column
tp_SizeDF__UserData__tp_Siz__239E4DCF(n/a)(n/a)(n/a)(n/a)(0)
PRIMARY KEY (clustered)UserData_PK(n/a)(n/a)(n/a)(n/a)tp_ListId, tp_ID
"John Kane" wrote:

> Dan,
> Can you post the exact SQL CONTAINS (or FREETEXT) query you are using along
> with the exact (including surrounding punctuation characters) text in the
> columns of your FT-enabled column? Could you also post the output of the
> following SQL code?
> use <your_database_name_here>
> go
> SELECT @.@.language
> SELECT @.@.version
> EXEC sp_help_fulltext_catalogs
> EXEC sp_help_fulltext_tables
> EXEC sp_help_fulltext_columns
> EXEC sp_help <your_FT-enable_table_name_here>
> go
> As you're using SQL Server 2000 SP3 on Windows 2000 Server (Win2K), the
> OS-supplied wordbreaker (infosoft.dll) when used with the US English
> "Language for Word Breaker" and depending upon your query and actual text
> not return the correct & expected results. See
> http://groups.google.com/groups?q=langwrbk+infosoft for past discussions on
> this OS-supplied wordbreaker issue.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:59B1B6D3-26B8-4CE7-91FB-E89698A6E816@.microsoft.com...
> same
> to
> I'm
> out
> might
> returning
> avail.
> I
> find
> the
> to
>
>
|||Dan,
First of all, thanks for providing the requested info! Although, I
understand why you can't post what is in the ntext2 column, but is the comma
in actual contact with the search word? For example is the exact text the
following (without the double quotes):
"calabasas," or ",calabasas"
Case does not matter as in the FT Catalog all words are converted to
uppercase characters. However, ANY punctuation characters that is touching
or in contact, i.e., not separated by a space and when used with the US
English "Language for Word Breaker" (LCID code 1033) with the Win2k
infosoft.dll wordbreaker are tokenized as on string. This is by design and
can only be worked around either by upgrading to Windows Server 2003 or by
dropping and re-creating the FT Catalog and using the Neutral "Language for
Word Breaker". Note, with the Neutral wordbreaker you will lose some
functionality i.e., inflectional search as the words are broken based upon
white space between the words.
Can you tell me if either of the following FTS queries returns more results
(assuming the comma as the punctuation character)?
select * from freetexttable(userdata,ntext2,'"calabasas,"')
-- or
select * from freetexttable(userdata,ntext2,'",calabasas"')
If not, then re-review the exact search text and include all punctuation
characters that are in contact with the search word.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:FAE25FDD-9596-4AE3-B343-3B97C0D278AC@.microsoft.com...
> Supposedly WSS searches with this...
> select *
> from freetexttable(userdata,ntext2,'calabasas')
> which returns 2 results
> If I do this...
> select *
> from userdata
> WHERE ntext2 LIKE'%calabasas%'
> I get 5 results
> I'm just searching the ntext2 column, but there are a lot of things in
there
> so I can't post it, but the searched for term is calabasas, and it's
always
> spelled the same way, in two cases it's all caps, and in both of those
cases
> it's followed by a comma (one instance is found, the other one isn't.)
>
> Result from running query:
> us_english
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT
> 5.0 (Build 2195: Service Pack 4)
> 5 ix_STS_LION_1 C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA 0 4
>
> dbo Docs Docs_IdUnique 1 1 ix_STS_LION_1
> dbo Lists Lists_FullText 2 1 ix_STS_LION_1
> dbo UserData UserData_FullText 15 1 ix_STS_LION_1
> dbo UserInfo UserInfo_FullText 4 1 ix_STS_LION_1
>
> dbo 1993058136 Docs LeafName 4 NULL NULL 1033
> dbo 1993058136 Docs Content 34 Extension 36 1033
> dbo 421576540 Lists tp_Title 3 NULL NULL 1033
> dbo 421576540 Lists tp_Description 27 NULL NULL 1033
> dbo 501576825 UserData nvarchar1 17 NULL NULL 1033
> dbo 501576825 UserData nvarchar2 18 NULL NULL 1033
> dbo 501576825 UserData nvarchar3 19 NULL NULL 1033
> dbo 501576825 UserData nvarchar4 20 NULL NULL 1033
> dbo 501576825 UserData nvarchar5 21 NULL NULL 1033
> dbo 501576825 UserData nvarchar6 22 NULL NULL 1033
> dbo 501576825 UserData nvarchar7 23 NULL NULL 1033
> dbo 501576825 UserData nvarchar8 24 NULL NULL 1033
> dbo 501576825 UserData nvarchar9 25 NULL NULL 1033
> dbo 501576825 UserData nvarchar10 26 NULL NULL 1033
> dbo 501576825 UserData nvarchar11 27 NULL NULL 1033
> dbo 501576825 UserData nvarchar12 28 NULL NULL 1033
> dbo 501576825 UserData nvarchar13 29 NULL NULL 1033
> dbo 501576825 UserData nvarchar14 30 NULL NULL 1033
> dbo 501576825 UserData nvarchar15 31 NULL NULL 1033
> dbo 501576825 UserData nvarchar16 32 NULL NULL 1033
> dbo 501576825 UserData nvarchar17 33 NULL NULL 1033
> dbo 501576825 UserData nvarchar18 34 NULL NULL 1033
> dbo 501576825 UserData nvarchar19 35 NULL NULL 1033
> dbo 501576825 UserData nvarchar20 36 NULL NULL 1033
> dbo 501576825 UserData nvarchar21 37 NULL NULL 1033
> dbo 501576825 UserData nvarchar22 38 NULL NULL 1033
> dbo 501576825 UserData nvarchar23 39 NULL NULL 1033
> dbo 501576825 UserData nvarchar24 40 NULL NULL 1033
> dbo 501576825 UserData nvarchar25 41 NULL NULL 1033
> dbo 501576825 UserData nvarchar26 42 NULL NULL 1033
> dbo 501576825 UserData nvarchar27 43 NULL NULL 1033
> dbo 501576825 UserData nvarchar28 44 NULL NULL 1033
> dbo 501576825 UserData nvarchar29 45 NULL NULL 1033
> dbo 501576825 UserData nvarchar30 46 NULL NULL 1033
> dbo 501576825 UserData nvarchar31 47 NULL NULL 1033
> dbo 501576825 UserData nvarchar32 48 NULL NULL 1033
> dbo 501576825 UserData nvarchar33 49 NULL NULL 1033
> dbo 501576825 UserData nvarchar34 50 NULL NULL 1033
> dbo 501576825 UserData nvarchar35 51 NULL NULL 1033
> dbo 501576825 UserData nvarchar36 52 NULL NULL 1033
> dbo 501576825 UserData nvarchar37 53 NULL NULL 1033
> dbo 501576825 UserData nvarchar38 54 NULL NULL 1033
> dbo 501576825 UserData nvarchar39 55 NULL NULL 1033
> dbo 501576825 UserData nvarchar40 56 NULL NULL 1033
> dbo 501576825 UserData nvarchar41 57 NULL NULL 1033
> dbo 501576825 UserData nvarchar42 58 NULL NULL 1033
> dbo 501576825 UserData nvarchar43 59 NULL NULL 1033
> dbo 501576825 UserData nvarchar44 60 NULL NULL 1033
> dbo 501576825 UserData nvarchar45 61 NULL NULL 1033
> dbo 501576825 UserData nvarchar46 62 NULL NULL 1033
> dbo 501576825 UserData nvarchar47 63 NULL NULL 1033
> dbo 501576825 UserData nvarchar48 64 NULL NULL 1033
> dbo 501576825 UserData nvarchar49 65 NULL NULL 1033
> dbo 501576825 UserData nvarchar50 66 NULL NULL 1033
> dbo 501576825 UserData nvarchar51 67 NULL NULL 1033
> dbo 501576825 UserData nvarchar52 68 NULL NULL 1033
> dbo 501576825 UserData nvarchar53 69 NULL NULL 1033
> dbo 501576825 UserData nvarchar54 70 NULL NULL 1033
> dbo 501576825 UserData nvarchar55 71 NULL NULL 1033
> dbo 501576825 UserData nvarchar56 72 NULL NULL 1033
> dbo 501576825 UserData nvarchar57 73 NULL NULL 1033
> dbo 501576825 UserData nvarchar58 74 NULL NULL 1033
> dbo 501576825 UserData nvarchar59 75 NULL NULL 1033
> dbo 501576825 UserData nvarchar60 76 NULL NULL 1033
> dbo 501576825 UserData nvarchar61 77 NULL NULL 1033
> dbo 501576825 UserData nvarchar62 78 NULL NULL 1033
> dbo 501576825 UserData nvarchar63 79 NULL NULL 1033
> dbo 501576825 UserData nvarchar64 80 NULL NULL 1033
> dbo 501576825 UserData ntext1 162 NULL NULL 1033
> dbo 501576825 UserData ntext2 163 NULL NULL 1033
> dbo 501576825 UserData ntext3 164 NULL NULL 1033
> dbo 501576825 UserData ntext4 165 NULL NULL 1033
> dbo 501576825 UserData ntext5 166 NULL NULL 1033
> dbo 501576825 UserData ntext6 167 NULL NULL 1033
> dbo 501576825 UserData ntext7 168 NULL NULL 1033
> dbo 501576825 UserData ntext8 169 NULL NULL 1033
> dbo 501576825 UserData ntext9 170 NULL NULL 1033
> dbo 501576825 UserData ntext10 171 NULL NULL 1033
> dbo 501576825 UserData ntext11 172 NULL NULL 1033
> dbo 501576825 UserData ntext12 173 NULL NULL 1033
> dbo 501576825 UserData ntext13 174 NULL NULL 1033
> dbo 501576825 UserData ntext14 175 NULL NULL 1033
> dbo 501576825 UserData ntext15 176 NULL NULL 1033
> dbo 501576825 UserData ntext16 177 NULL NULL 1033
> dbo 501576825 UserData ntext17 178 NULL NULL 1033
> dbo 501576825 UserData ntext18 179 NULL NULL 1033
> dbo 501576825 UserData ntext19 180 NULL NULL 1033
> dbo 501576825 UserData ntext20 181 NULL NULL 1033
> dbo 501576825 UserData ntext21 182 NULL NULL 1033
> dbo 501576825 UserData ntext22 183 NULL NULL 1033
> dbo 501576825 UserData ntext23 184 NULL NULL 1033
> dbo 501576825 UserData ntext24 185 NULL NULL 1033
> dbo 501576825 UserData ntext25 186 NULL NULL 1033
> dbo 501576825 UserData ntext26 187 NULL NULL 1033
> dbo 501576825 UserData ntext27 188 NULL NULL 1033
> dbo 501576825 UserData ntext28 189 NULL NULL 1033
> dbo 501576825 UserData ntext29 190 NULL NULL 1033
> dbo 501576825 UserData ntext30 191 NULL NULL 1033
> dbo 501576825 UserData ntext31 192 NULL NULL 1033
> dbo 501576825 UserData ntext32 193 NULL NULL 1033
> dbo 981578535 UserInfo tp_Login 8 NULL NULL 1033
> dbo 981578535 UserInfo tp_Title 9 NULL NULL 1033
> dbo 981578535 UserInfo tp_Email 10 NULL NULL 1033
>
> UserData dbo user table 2004-12-22 12:33:26.100
> tp_ID int no 4 10 0 no (n/a) (n/a) NULL
> tp_ListId uniqueidentifier no 16 no (n/a) (n/a) NULL
> tp_SiteId uniqueidentifier no 16 no (n/a) (n/a) NULL
> tp_Version int no 4 10 0 no (n/a) (n/a) NULL
> tp_Author int no 4 10 0 yes (n/a) (n/a) NULL
> tp_Editor int no 4 10 0 yes (n/a) (n/a) NULL
> tp_Modified datetime no 8 yes (n/a) (n/a) NULL
> tp_Created datetime no 8 yes (n/a) (n/a) NULL
> tp_Ordering varchar no 512 yes no no Latin1_General_CI_AS_KS_WS
> tp_HasAttachment bit no 1 no (n/a) (n/a) NULL
> tp_ModerationStatus int no 4 10 0 no (n/a) (n/a) NULL
> tp_IsCurrent bit no 1 no (n/a) (n/a) NULL
> tp_ItemOrder float no 8 53 NULL yes (n/a) (n/a) NULL
> tp_InstanceID int no 4 10 0 yes (n/a) (n/a) NULL
> tp_GUID uniqueidentifier no 16 no (n/a) (n/a) NULL
> tp_Size int no 4 10 0 no (n/a) (n/a) NULL
> nvarchar1 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar2 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar3 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar4 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar5 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar6 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar7 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar8 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar9 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar10 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar11 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar12 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar13 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar14 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar15 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar16 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar17 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar18 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar19 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar20 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar21 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar22 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar23 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar24 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar25 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar26 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar27 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar28 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar29 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar30 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar31 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar32 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar33 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar34 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar35 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar36 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar37 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar38 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar39 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar40 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar41 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar42 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar43 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar44 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar45 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar46 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar47 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar48 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar49 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar50 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar51 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar52 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar53 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar54 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar55 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar56 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar57 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar58 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar59 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar60 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar61 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar62 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar63 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> nvarchar64 nvarchar no 510
> yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> int1 int no 4 10 0 yes (n/a) (n/a) NULL
> int2 int no 4 10 0 yes (n/a) (n/a) NULL
> int3 int no 4 10 0 yes (n/a) (n/a) NULL
> int4 int no 4 10 0 yes (n/a) (n/a) NULL
> int5 int no 4 10 0 yes (n/a) (n/a) NULL
> int6 int no 4 10 0 yes (n/a) (n/a) NULL
> int7 int no 4 10 0 yes (n/a) (n/a) NULL
> int8 int no 4 10 0 yes (n/a) (n/a) NULL
> int9 int no 4 10 0 yes (n/a) (n/a) NULL
> int10 int no 4 10 0 yes (n/a) (n/a) NULL
> int11 int no 4 10 0 yes (n/a) (n/a) NULL
> int12 int no 4 10 0 yes (n/a) (n/a) NULL
> int13 int no 4 10 0 yes (n/a) (n/a) NULL
> int14 int no 4 10 0 yes (n/a) (n/a) NULL
> int15 int no 4 10 0 yes (n/a) (n/a) NULL
> int16 int no 4 10 0 yes (n/a) (n/a) NULL
> float1 float no 8 53 NULL yes (n/a) (n/a) NULL
> float2 float no 8 53 NULL yes (n/a) (n/a) NULL
> float3 float no 8 53 NULL yes (n/a) (n/a) NULL
> float4 float no 8 53 NULL yes (n/a) (n/a) NULL
> float5 float no 8 53 NULL yes (n/a) (n/a) NULL
> float6 float no 8 53 NULL yes (n/a) (n/a) NULL
> float7 float no 8 53 NULL yes (n/a) (n/a) NULL
> float8 float no 8 53 NULL yes (n/a) (n/a) NULL
> float9 float no 8 53 NULL yes (n/a) (n/a) NULL
> float10 float no 8 53 NULL yes (n/a) (n/a) NULL
> float11 float no 8 53 NULL yes (n/a) (n/a) NULL
> float12 float no 8 53 NULL yes (n/a) (n/a) NULL
> float13 float no 8 53 NULL yes (n/a) (n/a) NULL
> float14 float no 8 53 NULL yes (n/a) (n/a) NULL
> float15 float no 8 53 NULL yes (n/a) (n/a) NULL
> float16 float no 8 53 NULL yes (n/a) (n/a) NULL
> float17 float no 8 53 NULL yes (n/a) (n/a) NULL
> float18 float no 8 53 NULL yes (n/a) (n/a) NULL
> float19 float no 8 53 NULL yes (n/a) (n/a) NULL
> float20 float no 8 53 NULL yes (n/a) (n/a) NULL
> float21 float no 8 53 NULL yes (n/a) (n/a) NULL
> float22 float no 8 53 NULL yes (n/a) (n/a) NULL
> float23 float no 8 53 NULL yes (n/a) (n/a) NULL
> float24 float no 8 53 NULL yes (n/a) (n/a) NULL
> float25 float no 8 53 NULL yes (n/a) (n/a) NULL
> float26 float no 8 53 NULL yes (n/a) (n/a) NULL
> float27 float no 8 53 NULL yes (n/a) (n/a) NULL
> float28 float no 8 53 NULL yes (n/a) (n/a) NULL
> float29 float no 8 53 NULL yes (n/a) (n/a) NULL
> float30 float no 8 53 NULL yes (n/a) (n/a) NULL
> float31 float no 8 53 NULL yes (n/a) (n/a) NULL
> float32 float no 8 53 NULL yes (n/a) (n/a) NULL
> datetime1 datetime no 8 yes (n/a) (n/a) NULL
> datetime2 datetime no 8 yes (n/a) (n/a) NULL
> datetime3 datetime no 8 yes (n/a) (n/a) NULL
> datetime4 datetime no 8 yes (n/a) (n/a) NULL
> datetime5 datetime no 8 yes (n/a) (n/a) NULL
> datetime6 datetime no 8 yes (n/a) (n/a) NULL
> datetime7 datetime no 8 yes (n/a) (n/a) NULL
> datetime8 datetime no 8 yes (n/a) (n/a) NULL
> datetime9 datetime no 8 yes (n/a) (n/a) NULL
> datetime10 datetime no 8 yes (n/a) (n/a) NULL
> datetime11 datetime no 8 yes (n/a) (n/a) NULL
> datetime12 datetime no 8 yes (n/a) (n/a) NULL
> datetime13 datetime no 8 yes (n/a) (n/a) NULL
> datetime14 datetime no 8 yes (n/a) (n/a) NULL
> datetime15 datetime no 8 yes (n/a) (n/a) NULL
> datetime16 datetime no 8 yes (n/a) (n/a) NULL
> bit1 bit no 1 yes (n/a) (n/a) NULL
> bit2 bit no 1 yes (n/a) (n/a) NULL
> bit3 bit no 1 yes (n/a) (n/a) NULL
> bit4 bit no 1 yes (n/a) (n/a) NULL
> bit5 bit no 1 yes (n/a) (n/a) NULL
> bit6 bit no 1 yes (n/a) (n/a) NULL
> bit7 bit no 1 yes (n/a) (n/a) NULL
> bit8 bit no 1 yes (n/a) (n/a) NULL
> bit9 bit no 1 yes (n/a) (n/a) NULL
> bit10 bit no 1 yes (n/a) (n/a) NULL
> bit11 bit no 1 yes (n/a) (n/a) NULL
> bit12 bit no 1 yes (n/a) (n/a) NULL
> bit13 bit no 1 yes (n/a) (n/a) NULL
> bit14 bit no 1 yes (n/a) (n/a) NULL
> bit15 bit no 1 yes (n/a) (n/a) NULL
> bit16 bit no 1 yes (n/a) (n/a) NULL
> uniqueidentifier1 uniqueidentifier no 16 yes (n/a) (n/a) NULL
> ntext1 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext2 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext3 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext4 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext5 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext6 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext7 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext8 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext9 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext10 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext11 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext12 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext13 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext14 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext15 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext16 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext17 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext18 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext19 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext20 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext21 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext22 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext23 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext24 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext25 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext26 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext27 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext28 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext29 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext30 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext31 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> ntext32 ntext no 16 yes (n/a) (n/a) Latin1_General_CI_AS_KS_WS
> sql_variant1 sql_variant no 8016 yes no (n/a) NULL
> sql_variant2 sql_variant no 8016 yes no (n/a) NULL
> sql_variant3 sql_variant no 8016 yes no (n/a) NULL
> sql_variant4 sql_variant no 8016 yes no (n/a) NULL
> sql_variant5 sql_variant no 8016 yes no (n/a) NULL
> sql_variant6 sql_variant no 8016 yes no (n/a) NULL
> sql_variant7 sql_variant no 8016 yes no (n/a) NULL
> sql_variant8 sql_variant no 8016 yes no (n/a) NULL
>
> No identity column defined. NULL NULL NULL
> No rowguidcol column defined.
> PRIMARY
> UserData_FullText nonclustered, unique located on PRIMARY tp_GUID
> UserData_PK clustered, unique, primary key located on PRIMARY tp_ListId,
tp_ID
>
> DEFAULT on column
> tp_GUID DF__UserData__tp_GUI__22AA2996 (n/a) (n/a) (n/a) (n/a) (newid())
> DEFAULT on column
> tp_HasAttachment DF__UserData__tp_Has__1FCDBCEB (n/a) (n/a) (n/a) (n/a)
(0)
> DEFAULT on column
> tp_IsCurrent DF__UserData__tp_IsC__21B6055D (n/a) (n/a) (n/a) (n/a) (1)
> DEFAULT on column
> tp_ModerationStatus DF__UserData__tp_Mod__20C1E124 (n/a) (n/a) (n/a) (n/a)
(0)
> DEFAULT on column
> tp_Size DF__UserData__tp_Siz__239E4DCF (n/a) (n/a) (n/a) (n/a) (0)
> PRIMARY KEY (clustered) UserData_PK (n/a) (n/a) (n/a) (n/a) tp_ListId,
tp_ID[vbcol=seagreen]
>
> "John Kane" wrote:
along[vbcol=seagreen]
the[vbcol=seagreen]
text[vbcol=seagreen]
discussions on[vbcol=seagreen]
the[vbcol=seagreen]
There[vbcol=seagreen]
index?[vbcol=seagreen]
speaks[vbcol=seagreen]
so[vbcol=seagreen]
filter[vbcol=seagreen]
which[vbcol=seagreen]
results.[vbcol=seagreen]
This[vbcol=seagreen]
why[vbcol=seagreen]
search[vbcol=seagreen]
actual[vbcol=seagreen]
simple[vbcol=seagreen]
index/catalog?[vbcol=seagreen]
rebuilt/repopulated[vbcol=seagreen]
me[vbcol=seagreen]
fine[vbcol=seagreen]
|||Nope, query returned same results.
The weird thing about the comma, is that one of the calabasas, shows up, but
the other calabasas, does not.
Okay, I'll try dropping and re-creating. I hope it works, but wonder how
big an effect that can have, because there are three instances of calabasas
(no touching punctuation at all. In fact the only punctuation is the period
at the end of the sentence a few words up in all three cases) by itself, and
the search is only pulling one of them (and one with a comma.)
Thanks for the help, I'll let you know how it worked (after I figure out
where to specify the neutral word breaker when re-creating the catalog.)
"John Kane" wrote:

> Dan,
> First of all, thanks for providing the requested info! Although, I
> understand why you can't post what is in the ntext2 column, but is the comma
> in actual contact with the search word? For example is the exact text the
> following (without the double quotes):
> "calabasas," or ",calabasas"
> Case does not matter as in the FT Catalog all words are converted to
> uppercase characters. However, ANY punctuation characters that is touching
> or in contact, i.e., not separated by a space and when used with the US
> English "Language for Word Breaker" (LCID code 1033) with the Win2k
> infosoft.dll wordbreaker are tokenized as on string. This is by design and
> can only be worked around either by upgrading to Windows Server 2003 or by
> dropping and re-creating the FT Catalog and using the Neutral "Language for
> Word Breaker". Note, with the Neutral wordbreaker you will lose some
> functionality i.e., inflectional search as the words are broken based upon
> white space between the words.
> Can you tell me if either of the following FTS queries returns more results
> (assuming the comma as the punctuation character)?
> select * from freetexttable(userdata,ntext2,'"calabasas,"')
> -- or
> select * from freetexttable(userdata,ntext2,'",calabasas"')
> If not, then re-review the exact search text and include all punctuation
> characters that are in contact with the search word.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:FAE25FDD-9596-4AE3-B343-3B97C0D278AC@.microsoft.com...
> there
> always
> cases
> NT
> tp_ID
> (0)
> (0)
> tp_ID
> along
> the
> text
> discussions on
> the
> There
> index?
> speaks
> so
> filter
> which
> results.
> This
> why
> search
> actual
> simple
> index/catalog?
> rebuilt/repopulated
> me
> fine
>
>
|||THAT FIXED IT!!! I changed it to use the neutral wordbreaker and it seems to
be working.
Thank you both (Hilary and John) for all of your help on this.
"John Kane" wrote:

> Dan,
> First of all, thanks for providing the requested info! Although, I
> understand why you can't post what is in the ntext2 column, but is the comma
> in actual contact with the search word? For example is the exact text the
> following (without the double quotes):
> "calabasas," or ",calabasas"
> Case does not matter as in the FT Catalog all words are converted to
> uppercase characters. However, ANY punctuation characters that is touching
> or in contact, i.e., not separated by a space and when used with the US
> English "Language for Word Breaker" (LCID code 1033) with the Win2k
> infosoft.dll wordbreaker are tokenized as on string. This is by design and
> can only be worked around either by upgrading to Windows Server 2003 or by
> dropping and re-creating the FT Catalog and using the Neutral "Language for
> Word Breaker". Note, with the Neutral wordbreaker you will lose some
> functionality i.e., inflectional search as the words are broken based upon
> white space between the words.
> Can you tell me if either of the following FTS queries returns more results
> (assuming the comma as the punctuation character)?
> select * from freetexttable(userdata,ntext2,'"calabasas,"')
> -- or
> select * from freetexttable(userdata,ntext2,'",calabasas"')
> If not, then re-review the exact search text and include all punctuation
> characters that are in contact with the search word.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:FAE25FDD-9596-4AE3-B343-3B97C0D278AC@.microsoft.com...
> there
> always
> cases
> NT
> tp_ID
> (0)
> (0)
> tp_ID
> along
> the
> text
> discussions on
> the
> There
> index?
> speaks
> so
> filter
> which
> results.
> This
> why
> search
> actual
> simple
> index/catalog?
> rebuilt/repopulated
> me
> fine
>
>