I want to script my database objects and include both the create and drop statements. Suposedly, this was fixed in SP2 but my installation doesn't show this option. I tried looking under Tools | Options for the Scripting page but I can't see it. When I execute SELECT @@Version, it says Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
Am I missing something?