BUG: SQL Server Enterprise Manager Does Not Create New Table in Default Filegroup (262607)

SYMPTOMS

If you create a new table in the Microsoft SQL Server Enterprise Manager, the new table is not saved to the default filegroup if it is different from the PRIMARY filegroup.

WORKAROUND

To work around this issue and avoid the problem, you can do either of the following:

Use the Query Analyzer instead of Enterprise Manager to create the new table.

-or-
In Enterprise Manager, specify the default filegroup manually.

MORE INFORMATION

Steps to Reproduce the Problem

Create a new filegroup and set it as the default filegroup. To do this, run the following script in Query Analyzer:

create database StudyNWind

Alter Database StudyNwind
ADD Filegroup testgroup02
go

alter Database studynwind
add file
(name = 'testgrp02', filename = 'c:\mssql7\data\testgrp02.ndf', size = 5mb)
to filegroup testgroup02
go

ALTER DATABASE Studynwind
MODIFY FILEGROUP testgroup02 default
go

Create a table in Enterprise Manager. Note that the new table uses the PRIMARY filegroup instead of the testgroup02 filegroup.