Created a full text index on table met_db_prcd. This table has an id of 658101385.
CREATE FULLTEXT INDEX ON met_db_prcd(db_prcd_dsc, db_prcd_nm)
KEY INDEX Xmet_db_prcd2 on EMART_MET
WITH CHANGE_TRACKING MANUAL
I can see that I have pending changes by running the following command:
sp_fulltext_pendingchanges 658101385
1. Where are the pending changes stored?
In SQL Server 2005 the changes are stored in an Internal Map Table,unlike SQL Server 2000 which had a table sysfulltextnotify table. The stored procedure sp_fulltext_pendingchanges uses the underlining Map table to get relevent information
HTH
Vishal
|||Do you know what the name of the internal map table?
没有评论:
发表评论