up vote 2 down vote favorite

Most of the time when I generate script in SSMS, I have to changed the exact same number of settings in the Generate and Publish Scripts wizard. Is there a way to set the defaults in this wizard (particularly in the Advanced Scripting Options dialog?

If not, does anyone have any interesting ways of facilitating this need?

share|improve this question
1  
Tools -> Options -> SQL Server Object Explorer -> Scripting? – Martin Smith Oct 4 '12 at 20:39
Thanks @MartinSmith. This gets me half way there...one I am not seeing is where to set the default for 'Script DROP and CREATE' to 'Script DROP and CREATE'. It is weird that they have some but not all of the settings in the options. – Ben Jones Oct 4 '12 at 20:47
I haven't actually tested that these settings affect the wizard defaults either. Maybe they just affect what happens when you generate scripts by right clicking individual objects. – Martin Smith Oct 4 '12 at 20:54
I think your first comment is good enough for an answer. Will you add it as one so I can mark it as my answer? – Ben Jones Oct 5 '12 at 0:26
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.