In Microsoft Sql Server Management Studio most of times I need a set of advanced settings when generating script. For example I need to set "Script Drop and create" to true and "script extended properties" to false etc. Is there a way or registery items to change the default settings for ever so I don't set them again any time?

Exactly I mean these settings:

Database > Tasks > Generate Scripts > Advanced Scripting Options

1 Answer 1


Most of those settings can be found here:

Tools -> Options -> SQL Server Object Explorer -> Scripting

Of the two you specifically asked for, "Script extended properties" is present there. But "Script DROP and CREATE" is not. Perhaps it is called something different from one interface to the other, but I can't see anything that would correspond. It might be because Drop vs. Drop/Create vs. Create isn't so much an option as it is a "what do you want to do with this object?" decision.

(Tested in SSMS 17.9.1.)

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.