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: http://connect.microsoft.com/SQLServer/feedback/details/641893/management-studio-incorrect-scripting-of-parition-scheme.

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.