Microsoft KB Archive/262607

= BUG: SQL Server Enterprise Manager Does Not Create New Table in Default Filegroup =

Article ID: 262607

Article Last Modified on 11/25/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q262607



BUG #: 57858 (SQLBUG_70)



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.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.



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.

Additional query words: ent man entman SEM SSEM file group

Keywords: kbbug kbpending KB262607

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.