Switching Filegroups and Schemasin SQL 2005

• J R Prince

  Grasshopper

  Points: 14

  More actions

  January 19, 2007 at 8:20 pm

  #116023

  How do you switch objects between different filegroups and Schemas in SQL 2005?

  I ran into these problems recently, and could not find an answer.

  Any help would be appreciated. 

  Thanks,

  JP in Dallas, TX

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 19, 2007 at 10:58 pm

  #684494

  For schema change use "ALTER SCHEMA (Transact-SQL) " command...

  To move the table between the filegroup you have to recreate the clustered index with the filegroup specified....

  MohammedU
  Microsoft SQL Server MVP

• J R Prince

  Grasshopper

  Points: 14

  More actions

  January 20, 2007 at 7:35 am

  #684517

  Mohammed:

  Thank you.

  I also just noticed I posted to the wrong group, so I appreciate you still responding here.

  Thanks,

  JP