Identify Cumulative Updates applied to SQL Server 2005 SP3

  • Ivan Mohapatra

    SSCarpal Tunnel

    Points: 4452

    Welsh Corgi (1/12/2012)


    I'm moving a Database Server to a new Machine.

    The machine has SQL Server 2005 SP3 Standard Edition

    They do not want to go to a new SP

    The product version is 9.00.4262.00 which is between the following:

    SQL Server 2005 Service Pack 3 9.00.4035

    SQL Server 2005 Service Pack 4 9.00.5000.00

    How do I identify which cumulative update that I need to install so that the new machine is at the same version?

    Any help would be greatly appreciated.

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Product version Release Edition

    9.00.4262.00 SP3 Standard Edition

    SELECT @@version

    Microsoft SQL Server 2005 - 9.00.4262.00 (Intel X86) Aug 13 2009 17:08:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Sorry to say u But It is a QUESTION OF SQL SERVER 2005 So kindly post this one in SQL SERVER ADMINISTRATION GROUP.PLZ Guys Stop replying.

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply