I need to script with all options. Where are all the options?

In older versions of SQL Server, when you scripted an object you got a rather large panel that allowed you to set various options such items as DROP’s, users, and more. In SQL Server 2005+, when you right-click and object and select “Script” you don’t see these options. Why is that?

Our studies showed that most often people wanted to keep their options, but change the script destination. That was opposite of what we had. So we made the options the persistent setting, and the destination the right-click option.

So where are the options? They are under the Tools menu item, under Scripting. Set what you want there, and you’ll be able to use those options each time.