Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 864
  • Last Modified:

Repopulate Catalog is greyed out in SQL Server 2005

I recently upgraded from SQL 2000 to SQL 2005.  Rebuild and repopulation of the Full-Text Catalog worked fine, but now, the Repopulate button is greyed out in the Microsoft SQL Manager, and I cannot figure out how to setup a repopulate schedule.  Seems like a bug to me?   Running Windows 2003...
0
PelicanParts
Asked:
PelicanParts
1 Solution
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:

please try to use using system sp.

EXEC sp_fulltext_catalog 'catalogname', 'start_full'
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now