Post reply

Move large number of indexes to a new file grp.

  • October 6, 2002 at 5:48 pm

    #101270

    Hi all,

    I looking for a script that moves indexes from one physical location to another...basically from one file group to another...I've more than 500 indexes to move to their owne disk space...any ideas?

  • October 7, 2002 at 9:28 am

    #437951

    I'd write dynamic sql to do this. I would process through SYSINDEXES and use the "PRINT" statement to build the appropriate T-SQL statements to move the indexes.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

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

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