Meine liebe Frank,

I aim to help all those in need of better SQL scripts than those available out there.

If you have any issues with that, I would more than happy...

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

I wrote a script that reliably moves a table to another filegroup.

You can find it on

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

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

Omri Bahat

SQL Farms Solutions

http://www.sqlfarms.com

You can find a script that returns all this data for you at

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

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

Omri Bahat

SQL Farms Solutions

http://www.sqlfarms.com

I wrote a script that would move one table at a time to a new filegroup. You can use it and loop over all tables on your database, and move...

I wrote a script that moves a table between filegroups automatically for you. You can find the script at

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

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

Omri Bahat

SQL Farms Solutions

http://www.sqlfarms.com

You can find a script that would move the data, indexes, and more to a new filegroup on

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

You can find a reliable and more robust script to move the table data to a new filegroup on

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

There is a reliable script that moves tables between filegroups, and it is available on

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