Basics, just the basics please

Hello you geniuses,
I've read so many articles in here about full-text searching that it's all
beginning to slip out of my ears.
Most everyone seems to have gotten something working but then it ends up
with problems or issues when configurations change or something externally
effects it. As for me, I don't know if I have something working or not and
would just like to get the FTS working as part of Windows Sharepoint
Services (WSS).
SELECT @.@.version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: )
SELECT @.@.language:
us_english
OS: SBS2003 DC
Is there someplace that has a "SQL Full-Text Search Setup for Dummy's?" like
paper, so I can follow by the numbers rather than ponder just how much is
done and not done or jump in and out without understanding the root of how
FTS works? And does the FTS get set for ALL of SQL that's installed or just
per SQL Server Group? I have two groups; (LOCAL) (Windows NT) and
(SVR1 SHAREPOINT) (Windows NT), would they both be handled at the same time?
Any help would be appreciated by this addled brained IT guy,
Rich
Rich,
Well, thank you! I've not been called a "genius" in sometime! <G>
Unfortunately, books on this subject have been delayed for various reasons
(I'm writing one), so for now there is no "SQL Full-Text Search for Dummy's"
(yet), but look for one soon! In the meantime, the best place to start is
SQL Server 2000 Books online (BOL) using the search tab and search on "full
text search" using the double quotes. The basics are covered under titles
"Full-Text Query Architecture", "Full-Text Catalogs and Indexes" and
"Full-text Querying SQL Server Data". Also, you should review the BOL for
CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE and last but not least
"Full-Text Search Recommendations". Mostly, the best and easiest way to
FT-enable the database as well as table and columns is to launch the
Full-Text Indexing Wizard (sqlftwiz.exe) from the SQL Enterprise Manager and
it will prompt you through all the steps necessary to FT-enable and schedule
a Full Population for you or you can run a Full Population at your own
convience.
Yes, there are problems with SQL FTS, but mainly these are either FAQ's that
currently are not documented in KB articles (see a list of KB's below) or
are bugs or differences due to OS platforms, i.e., difference behavior and
results between Win2K and Win2003. Additionally, many SQL FTS issues are
related to either performance or scalability issues and lack of
customization. FYI, many of these bugs are being addressed by Microsoft in
the next release of SQL Server 2005 (codename Yukon).
You should also review the FTS Deployment whitepaper (I was a *contributor*)
and how to enable at:
http://support.microsoft.com/default...per.asp#enable
Q. And does the FTS get set for ALL of SQL that's installed or just per SQL
Server Group? I have two groups; (LOCAL) (Windows NT) and (SVR1
SHAREPOINT) (Windows NT), would they both be handled at the same time?
A. Yes and no... Specifically, FTS is installed and functional for both your
local and SVR1 SHAREPOINT (named instance), however, each server's database
must be FT-enabled separately via the FT Indexing Wizard.
Hope that helps!
John
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:eRVef2JhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> Hello you geniuses,
> I've read so many articles in here about full-text searching that it's all
> beginning to slip out of my ears.
> Most everyone seems to have gotten something working but then it ends up
> with problems or issues when configurations change or something externally
> effects it. As for me, I don't know if I have something working or not
and
> would just like to get the FTS working as part of Windows Sharepoint
> Services (WSS).
> SELECT @.@.version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: )
> SELECT @.@.language:
> us_english
> OS: SBS2003 DC
> Is there someplace that has a "SQL Full-Text Search Setup for Dummy's?"
like
> paper, so I can follow by the numbers rather than ponder just how much is
> done and not done or jump in and out without understanding the root of how
> FTS works? And does the FTS get set for ALL of SQL that's installed or
just
> per SQL Server Group? I have two groups; (LOCAL) (Windows NT) and
> (SVR1 SHAREPOINT) (Windows NT), would they both be handled at the same
time?
> Any help would be appreciated by this addled brained IT guy,
> Rich
>
|||John,
Thanks for your reply. I've got some reading to do, thanks for the lead.
On the other issue I raised, regarding whether or not two groups would be
handled as one, you indicated that both would need to have FTS set up
through the wizard for FTS to take effect.
The two groups I have are like this:
Microsoft SQL Servers
SQL Server Group
(LOCAL) (Windows NT)
(SVR1\SHAREPOINT) (Windows NT)
When I highlight the LOCAL one, I get (under Tools) Full-Text Indexing... as
an enabled choice. But when I highlight the SHAREPOINT one, the Full-Text
Indexing... is greyed out.
I checked under Security on both and then Logins and both have
BUILTIN\Administrators (group) and CMSouth\Administrator (user) (CMSouth is
the domain name of SVR1). Along with an 'sa' for both.
Is there something I'm missing here? When I go into the Query Analyzer and
it prompts for the server to connect to, it only offers "local" and not the
SHAREPOINT database group.
I would appreciate any light you might shed on this.
Rich
PS: And yes, I did say genius. Anyone who can understand this as well as
you deserves that label.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:unU3fPMhEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Rich,
> Well, thank you! I've not been called a "genius" in sometime! <G>
> Unfortunately, books on this subject have been delayed for various reasons
> (I'm writing one), so for now there is no "SQL Full-Text Search for
Dummy's"
> (yet), but look for one soon! In the meantime, the best place to start is
> SQL Server 2000 Books online (BOL) using the search tab and search on
"full
> text search" using the double quotes. The basics are covered under titles
> "Full-Text Query Architecture", "Full-Text Catalogs and Indexes" and
> "Full-text Querying SQL Server Data". Also, you should review the BOL for
> CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE and last but not least
> "Full-Text Search Recommendations". Mostly, the best and easiest way to
> FT-enable the database as well as table and columns is to launch the
> Full-Text Indexing Wizard (sqlftwiz.exe) from the SQL Enterprise Manager
and
> it will prompt you through all the steps necessary to FT-enable and
schedule
> a Full Population for you or you can run a Full Population at your own
> convience.
> Yes, there are problems with SQL FTS, but mainly these are either FAQ's
that
> currently are not documented in KB articles (see a list of KB's below) or
> are bugs or differences due to OS platforms, i.e., difference behavior and
> results between Win2K and Win2003. Additionally, many SQL FTS issues are
> related to either performance or scalability issues and lack of
> customization. FYI, many of these bugs are being addressed by Microsoft in
> the next release of SQL Server 2005 (codename Yukon).
> You should also review the FTS Deployment whitepaper (I was a
*contributor*)
> and how to enable at:
>
http://support.microsoft.com/default...per.asp#enable
>
> Q. And does the FTS get set for ALL of SQL that's installed or just per
SQL
> Server Group? I have two groups; (LOCAL) (Windows NT) and (SVR1
> SHAREPOINT) (Windows NT), would they both be handled at the same time?
> A. Yes and no... Specifically, FTS is installed and functional for both
your
> local and SVR1 SHAREPOINT (named instance), however, each server's
database[vbcol=seagreen]
> must be FT-enabled separately via the FT Indexing Wizard.
> Hope that helps!
> John
>
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:eRVef2JhEHA.3272@.TK2MSFTNGP11.phx.gbl...
all[vbcol=seagreen]
externally[vbcol=seagreen]
> and
Windows[vbcol=seagreen]
> like
is[vbcol=seagreen]
how
> just
> time?
>
|||You're welcome, Rich !
Under your SHAREPOINT named instance of SQL Server, could you run the
following code and post the result?
EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOIN T', 'ObjectName'
go
The output Data should be the exact account that this named instance
(SHAREPOINT) is running under. If it is a local Windows account, this could
explain why the Full-Text Indexing menu items are grayed out. If so, please
review KB article Q270671 (Q270671) "PRB: Full Text Search Menus Are Not
Enabled for Local Windows NT Accounts" at:
http://support.microsoft.com/default...;en-us;q270671 You should
test using the system stored procs sp_fulltext_* to see if you can create a
FT Catalog and run a Full Population. If you can change the SQL Server named
instance (SHAREPOINT) startup account to a new or existing DOMAIN\Account
that is a member of the server's Admin. Group, and not the DOMAIN
Administrator account (I'm assuming that CMSouth\Administrator is the Domain
Admin account) that could solve this issue too.
Thanks,
John "Genius" Kane ;-))
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:#9vvgTVhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> John,
> Thanks for your reply. I've got some reading to do, thanks for the lead.
> On the other issue I raised, regarding whether or not two groups would be
> handled as one, you indicated that both would need to have FTS set up
> through the wizard for FTS to take effect.
> The two groups I have are like this:
> Microsoft SQL Servers
> SQL Server Group
> (LOCAL) (Windows NT)
> (SVR1\SHAREPOINT) (Windows NT)
> When I highlight the LOCAL one, I get (under Tools) Full-Text Indexing...
as
> an enabled choice. But when I highlight the SHAREPOINT one, the Full-Text
> Indexing... is greyed out.
> I checked under Security on both and then Logins and both have
> BUILTIN\Administrators (group) and CMSouth\Administrator (user) (CMSouth
is
> the domain name of SVR1). Along with an 'sa' for both.
> Is there something I'm missing here? When I go into the Query Analyzer
and
> it prompts for the server to connect to, it only offers "local" and not
the[vbcol=seagreen]
> SHAREPOINT database group.
> I would appreciate any light you might shed on this.
> Rich
> PS: And yes, I did say genius. Anyone who can understand this as well as
> you deserves that label.
>
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:unU3fPMhEHA.3664@.TK2MSFTNGP11.phx.gbl...
reasons[vbcol=seagreen]
> Dummy's"
is[vbcol=seagreen]
> "full
titles[vbcol=seagreen]
for[vbcol=seagreen]
least[vbcol=seagreen]
> and
> schedule
> that
or[vbcol=seagreen]
and[vbcol=seagreen]
in
> *contributor*)
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> SQL
> your
> database
> all
up[vbcol=seagreen]
> externally
not[vbcol=seagreen]
14:22:05[vbcol=seagreen]
> Windows
Dummy's?"[vbcol=seagreen]
> is
> how
or
>