all groups > sql server full text search > march 2004 >
You're in the

sql server full text search

group:

Full Text Search on XP Pro


Full Text Search on XP Pro John
3/22/2004 12:46:09 PM
sql server full text search:
All

I have the Developer edition running on XP Pro. I "added" FTS as it was not done automatically during the regular installation. The box is checked when I run the installation CD and check the options that I can add

I cannot however get FTS to enable. When I try to access it under the Enterprise Manager, it is disabled. Is FTS supported in XP Pro with the developer edition

Any help would be appreciated

Re: Full Text Search on XP Pro Hilary Cotter
3/24/2004 10:13:49 PM
yes it is enabled. Check out this link for more information possibly
relating to this problem

http://support.microsoft.com/default.aspx?scid=kb;en-us;270671

Also try the full text stored procedures to see if they work, but the wizard
doesn't

use pubs
go
exec sp_fulltext_catalog 'test','create'
go
exec sp_fulltext_table N'[dbo].[authors]', N'create', N'test',
N'index_1977058079'
go
sp_fulltext_column N'[dbo].[authors]', N'au_lname', 'add', 1033,null
go
exec sp_fulltext_table N'[dbo].[authors]', N'activate'
go
exec sp_fulltext_table 'authors', 'Start_change_tracking'
go
exec sp_fulltext_table 'authors', 'Start_background_updateindex'
go

Sometimes EM is a little funky when it comes to administering SQL FTS,
sometimes it seems like I have to refresh the catalog and look at its
properties to enable the Full text menus in EM.




[quoted text, click to view]
not done automatically during the regular installation. The box is checked
when I run the installation CD and check the options that I can add.
[quoted text, click to view]
Enterprise Manager, it is disabled. Is FTS supported in XP Pro with the
developer edition?
[quoted text, click to view]

AddThis Social Bookmark Button