SQLExpress FT doesn't change tracking

SQLExpress FT doesn't change tracking

Post by T2xlZ » Thu, 07 Jun 2007 03:24:01


I have 2 servers: Enterprise edition and Express.(2005, SP2)
I restored the db from the same backup.
Then created FT catalogs using this stmts:

CREATE FULLTEXT CATALOG [FTSearchCat]
CREATE FULLTEXT INDEX ON [dbo].[strings_catalog] KEY INDEX
[PK_strings_catalog] ON [FTSearchCat] WITH CHANGE_TRACKING AUTO
ALTER FULLTEXT INDEX ON [dbo].[strings_catalog] ADD ([string] LANGUAGE
[English])
ALTER FULLTEXT INDEX ON [dbo].[strings_catalog] ENABLE

After this on the Enterprise I see data changes immediately in FT queries.
But on the Express have only static catalog, i.e. no changes.

May be its restriction of Express FT Search?
Thank you.
 
 
 

1. "Track Changes" - Prevent turn off track changes to meet SOX regs

2. Track Changes After Save Changes Tracking Word 2003

This is an odd problem that one of the attorneys brought to my attention and
I must find a resolution. I am extremely well-versed regarding Word but this
one has me stumped.

Example:
Attorney will open an existing document, turns track changes on, and type
several lines of text (Call is TextA). He can go back and edit those lines
of text without deletions showing up as deletions. However, once he saves
the document, and goes back to edit the lines of text he just inserted
(TextA), any deletions he makes now show up as new deletions (strikethrough
text).

Any suggestions on how to avoid this from occurring (other than not saving!
:) would be greatly appreciated.

Thank you in advance.
--
Joanne Orzech

3. track word changes ON while track formatting changes is OFF

4. Change Tracking Tracks Changes to New Text - It's Crazy!

5. Upgrade from SQLExpress 2008 to SQLExpress 2008 w/advanced services?

6. Turning Off tracking formatting changes using track changes

7. Track changes turned off- yet continues to track changes

8. Converting Decimal Ft into Ft & In

9. US-PA: Ft Washington-Senior Applications Developer - Ft. Washington, PA

10. US-PA: Ft Washington-Siebel 7 Developer needed in Ft Washington for a 3-6...

11. set page to 50 ft by 20 ft

12. US-PA: Ft Washington-Senior Applications Developer - Ft. Washington, PA

13. US-PA: Ft Washington-Siebel 7 Developer needed in Ft Washington for a 3-6...

14. Which FT-infrastructures are themselves FT/HT?

15. if ((ft/2) == (total/2)) works, if ((ft/10) == (total/10)) NO!