SQL Server 2005 Management Studio Scripting Bug Fixes not found

Posted on 2009-04-27
Last Modified: 2012-05-06
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?
Question by:ZekeLA
    LVL 3

    Accepted Solution

    If you are on build 9.00.1399 then you are on the RTM version of SQL2005 with no Service Pack. You probably want to download Service Pack 3 for SQL2005 which can be found here
    LVL 1

    Author Closing Comment

    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.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    27 Experts available now in Live!

    Get 1:1 Help Now