• I guess the easiest way to move objects to a different filegroup would be to use Enterprise Manager.

    Look at BOL for filegroups -> switching filegroup for table

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]