SQL Server SP4

  • I have updated my SQL 2005 server with SP4 .Is there any cumulative update or hotfixes need to be applied after this

    Akkare

  • There are CU's and hotfixes available after SP4 for 2005, its up to you if you want to install them or not

    http://sqlserverbuilds.blogspot.co.uk/

  • Referring to the link Anthony provided, at minimum I would recommend applying this security update:

    * 9.00.50572005.90.5057.02494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011

    Ideally I would recommend applying CU3 and everything newer than that (listed from newest to oldest, but apply from oldest to newest):

    * 9.00.53242005.90.5324.02716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE

    * 9.00.52962005.90.5296.02615425 FIX: "Msg 7359" error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updated

    * 9.00.52952005.90.5295.02598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

    * 9.00.52942005.90.5294.02572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005

    * 9.00.52922005.90.5292.02494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011

    * 9.00.52662005.90.5266.02507769 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 4

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

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