What SP am I on? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

What SP am I on?

Author

Topic

JohnBGood
Starting Member

48 Posts

Posted - 2009-10-30 : 21:05:20

after running SELECT @@VERSION, i get the following result:

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

however when I run en_sql_server_2005_sp3_x86.exe (AKA Service Pack 3) ...the dialog says I'm already "upgraded" for each of the components.

Can I force a rollback to SP2 somehow???

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-10-30 : 22:25:21

[code]
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')[/code]

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-10-30 : 22:28:37

by the way, build 4035 is SP3

why do you want to roll back? the "service pack 2" in the output is windows service pack, not SQL service pack

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-30 : 23:02:02

You are missing the critical SQL hotfix that was released in early October.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

JohnBGood
Starting Member

48 Posts

Posted - 2009-10-31 : 08:03:17

Wonderful. Thanks VERY Much!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources