Post reply

List filegroups in partition scheme

  • July 9, 2013 at 12:25 pm

    #277106

    Hi all,

    I am getting the following error when I try to split a partition function, but I can't find any way to get list of filegroups in the scheme. Anyone have any suggestions or better yet any script? Thanks in advance.

    The associated partition function MyPartitionFunction generates more partitions than there are file groups mentioned in the scheme 'MyPartitionScheme'

  • July 9, 2013 at 4:17 pm

    #1631019

    You have that information in sys.destination_data_spaces.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • July 9, 2013 at 4:31 pm

    #1631021

    got it, many thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply