Post reply

Change file group for all indexes in db

  • January 23, 2004 at 9:58 am

    #161398

    Does anyone have a script that will go through a database and switch the index from one file group to another for every table/index?

     

    Thanks,

    Jamey Hines


    - JH

  • January 23, 2004 at 10:37 am

    #491429

    Check the script library, but this would not be hard. Select from sysindexes, build a command line to rebuild the index, add the clause to move to filegroups and exec() it.

     

Viewing 2 posts - 1 through 1 (of 1 total)

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