Changing the Default Filegroup

When you change the default filegroup, any objects for which no filegroups have been initially specified are allocated to the data files in the new default filegroup. Changing the default filegroup prevents user objects that are not specifically created on a user-defined filegroup from competing with the system objects and tables for data space.

To change the default filegroup

    

See Also

Default Filegroups

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.