1

I reinstalled Windows 10 from scratch.

I'm trying to get SSMS options setup the way I like them. When I r-click a DB, then Tasks->GenerateScripts, the result doesn't contain SCOPED CONFIGURATION lines anymore. I checked the various SSMS scripting options and don't see one specifically for SCOPED CONFIGURATION.

  • Does anyone have ideas on why GenerateScripts doesn't include SCOPED CONFIGURATION lines?

SSMS 17.9.1 SQL Server 14.0.2002.

Thank you in advance.

6
  • I am using SSMS 18.0, it is scripting out The database scoped configuration i just changed as a test when scripting out the full (azure sql db) database Dec 6, 2018 at 20:57
  • Are you by any chance scripting for a server version lower than 2016? Dec 6, 2018 at 21:03
  • 2
    learn.microsoft.com/en-us/sql/ssms/…
    – CR241
    Dec 6, 2018 at 21:41
  • @CR241 that is probably it, I'd say you could post it as the answer when Greg validates this. Dec 6, 2018 at 21:54
  • I was scripting for 2017. I also tried Azure DB (our production DBs). Dec 6, 2018 at 23:17

1 Answer 1

2

why GenerateScripts doesn't include SCOPED CONFIGURATION lines?

Because When scripting objects, DB Scoped configuration that has default values are omitted.

Check SQL Server Management Studio - Changelog (SSMS) for more information.

SSMS 18.0 (preview 4) -> Bug fixes -> Object Scripting

1
  • I'll try the v18 preview. This would explain things... Thank you Dec 6, 2018 at 23:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.