Need help moving a table to another filegroup

• laker_42

  SSCarpal Tunnel

  Points: 4785

  More actions

  November 27, 2002 at 10:32 am

  #80414

  I am trying to move a table from the primary filegroup to our userdata filegroup. I did find a way to do it manually through Enterprise Manager. Since we have a hundred or so tables, I would rather find a way to script it. I would appreciate any info or ideas you can offer!

  Thanks,

  John

• Antares686

  SSC Guru

  Points: 125444

  More actions

  December 1, 2002 at 8:43 pm

  #442717

  Duplicate post, please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8471&FORUM_ID=9&CAT_ID=1&Topic_Title=Need+help+moving+a+table+to+another+filegroup&Forum_Title=General. Can an admin please lock.

• Omri Bahat-228920

  Mr or Mrs. 500

  Points: 540

  More actions

  June 21, 2005 at 7:53 am

  #567034

  I wrote a script that moves a table between filegroups. It's long, but thoroughly tested.

  You can find it on

  http://education.sqlfarms.com/ShowPost.aspx?PostID=59

  ----------------------------

  Omri Bahat

  SQL Farms Solutions

  http://www.sqlfarms.com

  Editor's Note: : Dr. Omri Bahat works for SQLFarms, a software vendor of SQL Server tools.