How to set up default advanced scripting options in Generate Scripts wizard?
I wonder if this is possible, and if so how to do this. Like, when you run the Generate Scripts Wizard, "Set Scripting Options" - "Advanced Scripting Options" tab, where do the default settings in the list coming from? Can I set them up to my needs, instead of checking/unchecking them every time? Thank you, - Tatyana
Go to the "View" menu in SSMS. Select "Template Explorer". That giant list of T-SQL templates are what's used as a basis for code generation. You can modify those. Unfortunately, there's no easy way to share that with a team.