Jan 15, 2009 #1 Tomi Programmer Nov 19, 2001 57 US Is there any system table or view that stores the last population date of Full text catalogs? (SQL 2000 or SQL 2005) Thanks Tomi
Is there any system table or view that stores the last population date of Full text catalogs? (SQL 2000 or SQL 2005) Thanks Tomi
Jan 18, 2009 1 #2 mrdenny Programmer May 27, 2002 11,595 Check the sys.fulltext_indexes DMV. See if that has what you are looking for. Denny MVP MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005) My Blog Upvote 0 Downvote
Check the sys.fulltext_indexes DMV. See if that has what you are looking for. Denny MVP MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005) My Blog