I am using SQL Server 2005. If I try to generate a script for DB using the Generated Scripts Wizard in Management Studio (Right click DB-> Work-> Generate Scripts)
I have no choice Like drop status in the list is present. While some SQL Server installed on different machines have enabled this option.
Is the service pack missing or an option to get this feature needed to be modified?
If you right-click, then there is a page in the wizard, where you set your scripting option can do. An option " is not included is included" or tools to set -> Options -> SQL Server Object Explorer-> Scripting.
Comments
Post a Comment