<div>
Doh. I looked quickly at the version info and see Service Pack 3 and don't notice it's for the OS, not the software. Thank you.
</div>


Doh. I looked quickly at the version info and see Service Pack 3 and don't notice it's for the OS, not the software. Thank you.

<div>
<div class="content wysiwyg-content">
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) &nbsp; Oct 14 2005 00:33:37 &nbsp; Copyright (c) 1988-2005 Microsoft Corporation &nbsp;Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3) <br />
<br />
Am I missing something? 
</div>
</div>


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? 

SQL Server 2005 Management Studio Scripting Bug Fixes not found

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.