SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Database Engine)

SQL Server Management Objects

SQL Server Management Objects Reference

Microsoft.SqlServer.Management.Smo

PartitionScheme Class

PartitionScheme Properties

Events Property

ExtendedProperties Property

FileGroups Property

ID Property

ISfcSupportsDesignMode.IsDesignMode Property

Name Property

NextUsedFileGroup Property

Parent Property

PartitionFunction Property

Minimize

This topic has not yet been rated - Rate this topic

PartitionScheme.NextUsedFileGroup Property

SQL Server 2012

SQL Server 2005

Gets or sets the name of the filegroup that has NEXT USED status.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string NextUsedFileGroup { get; set; }

Property Value

Type: System.String
A String value that specifies the filegroup name.

Returns an empty string if no filegroup has NEXT USED status.

Using Filegroups and Files to Store Data

Reference

PartitionScheme Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PARTITION SCHEME (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.