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
Showing posts with label fulltext. Show all posts
Showing posts with label fulltext. Show all posts
Friday, February 24, 2012
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.
>
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.
>
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.
>
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.
>
Subscribe to:
Posts (Atom)