Partilhar via

ApplicationDatabaseOptions.DefaultFileGroup Property

  • Artigo

Gets or sets the default filegroup for the application database.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property DefaultFileGroup As String

public string DefaultFileGroup { get; set; }

public:
property String^ DefaultFileGroup {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_DefaultFileGroup ()

/** @property */
public void set_DefaultFileGroup (String value)

public function get DefaultFileGroup () : String

public function set DefaultFileGroup (value : String)

Property Value

A String containing name of the default filegroup.

Remarks

The default filegroup must be the name of one of the ApplicationDatabaseFileGroup objects for this application. Any application object without a specified filegroup is created in the default filegroup. If you do not specify a default filegroup, the default is PRIMARY.

Example

The following examples show how to set the application database collation:

adb.DefaultFileGroup = "PRIMARY";

adb.DefaultFileGroup = "PRIMARY"

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

ApplicationDatabaseOptions Class
ApplicationDatabaseOptions Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

Defining the Application Database
DefaultFileGroup Element (ADF)