Showing posts with label fulltext. Show all posts
Showing posts with label fulltext. Show all posts

Friday, February 24, 2012

Developer Edition issues and fulltext searching

I have SQLServer 2000 (Developer edition) and have installed SP3a in
an attempt to get full word in text searching. (both installed as
administrator on a Windows XP professional box)
However, I dont get MSSEARCH in the list of services and hence the
'Full Text' Indexing option is grayed out.
Also:
sp_fulltext_database 'enable' -- returns the following
(1 row(s) affected)
Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot be
loaded.
HELP
re-run SQL Server setup and select the add additional components option. Select Full Text Search here.
|||Add/Remove Programs -> Windows Components -> Check "Indexing Service"
Bojidar Alexandrov

Friday, February 17, 2012

dettache fulltext

Is it possible like Sybase to have the fulltext engine on another host ? If
yes how to proceed, if not why ?
Thanks by advance for your responses.ljbx,
You can't put the catalogs on a separate server, however you can put
them on separate RAID arrays, or on a LUN on your SAN. This might be a
good way to improve performance.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
ljbx wrote:
> Is it possible like Sybase to have the fulltext engine on another host ? I
f
> yes how to proceed, if not why ?
> Thanks by advance for your responses.
>

dettache fulltext

Is it possible like Sybase to have the fulltext engine on another host ? If
yes how to proceed, if not why ?
Thanks by advance for your responses.
ljbx,
You can't put the catalogs on a separate server, however you can put
them on separate RAID arrays, or on a LUN on your SAN. This might be a
good way to improve performance.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
ljbx wrote:
> Is it possible like Sybase to have the fulltext engine on another host ? If
> yes how to proceed, if not why ?
> Thanks by advance for your responses.
>

dettache fulltext

Is it possible like Sybase to have the fulltext engine on another host ? If
yes how to proceed, if not why ?
Thanks by advance for your responses.ljbx,
You can't put the catalogs on a separate server, however you can put
them on separate RAID arrays, or on a LUN on your SAN. This might be a
good way to improve performance.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
ljbx wrote:
> Is it possible like Sybase to have the fulltext engine on another host ? If
> yes how to proceed, if not why ?
> Thanks by advance for your responses.
>