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 site uses Akismet to reduce spam. Learn how your comment data is processed.