Post reply

Script out full text catalogs

  • May 20, 2008 at 2:40 pm

    #122339

    Is it possible to script out ful text catalogs? I have to create 20 new catalogs in production server as they are there in development one?

    Please help.

    Manu

  • May 21, 2008 at 9:47 am

    #818680

    In SSMS, expand the database, expand Storage, expand Full Text Catalogs, right-click a catalog and select "script catalog as". I can't find a way to script all full-text catalogs in an instance at once.

    Greg

  • May 21, 2008 at 3:29 pm

    #818891

    Thanks Greg. Is there any similar option avaialble in SQL Server 2000?

  • May 22, 2008 at 8:50 am

    #819183

    No. Build it yourself by selecting from sysfulltextcatalogs in each database.

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply