Each table and each index in the Eval database is associated with a filegroup. Unless you specify otherwise, SQL Server uses the default filegroup when you create new tables and indexes. The Eval database uses the primary filegroup as the default filegroup. You select the filegroup for tables on the Tables tab and the filegroup for indexes on the Indexes/Keys tab of the Properties dialog box for the table. You can also create any text, ntext, or image columns within a table on a filegroup other than the filegroup that contains the base table. You specify this filegroup in the Text File Group drop-down list box. The following illustration shows the Tables tab and the Indexes/Keys tab of the Properties dialog box for the Activity table.
