I know how to use Enterprise Manager to move a table to a different filegroup. But I want to automate the process by using T-SQL to move a table—not just its indexes—to a different filegroup. How do I do this?

Enterprise Manager moves a table from one filegroup to another without using an undocumented task, but T-SQL doesn't have a command that does the same thing. The easiest way to move a table to another filegroup is to create a clustered index on the table. If th...