You are here

SSMS Scripting Partition Scheme With Correct Filegroup

I almost found a bug… but it’s a feature after all.

If you are scripting out a Partition Scheme in SSMS, you might notice that your script defaults to the PRIMARY filegroup. For the reason why, go here:

To fix it, go into SSMS Tools, Options, SQL Server Object Explorer, Scripting, and under the heading “Table and view options”, change “Script file groups” to True.

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
9 + 10 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer