SSMS Scripting Partition Scheme With Correct Filegroup

ben himself's picture

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.