Question: I'd like to add a table to a different FILEGROUP . The problem I've got is I don't have enough room on a drive and would like to add another file

in another filegroup, onto a new drive . What are the steps required?

Answer: This is a common problem, and can be achieved in three steps. A typical situation is where you've discovered there isn't enough disk space on the current drive and you have a temporary job - requiring some temp disk space.

In summary these are the steps :

a) Create a new filegroupb) Add a file to the new FILEGROUPc) Create the table and associate to the new FILEGROUP