Export (0) Print
Expand All

Changing the Default Filegroup

SQL Server 2000

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

Transact-SQL

SQL-DMO

See Also

Default Filegroups

Show:
© 2014 Microsoft