[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • Last Modified:

Service Pack(SP3)

How can I find out if I am running SQL Server 2005 SP2 Cummulative update 10 or SQL Server 2005 SP2 Cummulative 11.
When I issue the commant: "SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')" I only see: "9.00.3080.00  SP2  Standard Edition(64-bit).
0
vera2006
Asked:
vera2006
1 Solution
 
tigin44Commented:
after installing the SQL Server 2005 SP2 Cumulative update 10 the build number will be  9.0.3294.0
and after installing the  SQL Server 2005 SP2 Cumulative update 10 the build number will be  9.0.3301.0

so your database is at an earlier state. It would be better that you should install service pack 3 rather than installing the cumulative updates unless a facing a problem that is not resolved in the service pack. Remember that the cumulative updates are not fully tested as the service packs.
0
 
sureshchsahuCommented:
For SQL Server 2005 SP2 Cummulative update 10

Cumulative Update 10 contains hotfixes for SQL Server 2005 Service Pack 2 issues that have been fixed since the release of SQL Server 2005 Service Pack 2.
Note:  This build of the cumulative update package is also known as build 9.00.3294.

For SQL Server 2005 SP2 Cummulative update 11
SQL Server 2005 Service Pack 2 Cumulative Update 11 contains hotfixes for SQL Server 2005 Service Pack 2 issues that have been fixed since the release of SQL Server 2005 Service Pack 2.
Note: This build of the cumulative update package is also known as build 9.00.3301

When u enter the following commnad
Select @@version
u will find the build <number> by looking on the number compare the number which has mentioned above  that will tell u whether it is Cumulative Update 10 or 11

0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now