SQL Server 2005 Management Studio Scripting Bug Fixes not found

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?
LVL 1
ZekeLAAsked:
Who is Participating?
 
rjbookCommented:
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 http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
0
 
ZekeLAAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.