SQL Server Performance Forum – Threads Archive

Hot fixes

Hi, Anybody aware of any latest Hot fix released by microsft after sql server 2005 SP2(March 5 Release)? I saw cumulative hot fix package (3152 build) but not able to make out whether this has to be applied after sp2 latest release .Microsoft confused a lot by releasing Sp2 (first release) and sp2 (second release) with lot of file versions and DLL versions. (KB933097 & KB93350<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> Thanks Chetana

Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is available
http://support.microsoft.com/kb/935356 The SQL Server 2005 Build List
http://www.sqlservercentral.com/columnists/sjones/2960.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

See this bloghttp://blogs.msdn.com/psssql/archiv…-2005-service-pack-2-sp2-fixes-explained.aspx from Dev. team in this regard that should clear out all your doubts. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Mohammedu-
Just correct me if i’m wrong ..if i install the latest SP2 the build automatically becomes 3161 and there is no seperate hotfix package (3161) as such. Is that what it says?

Yes it is available with the latest re-relase of SP2, as per the blog too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

satya- I just checked up with microsoft … It seems they have not yet released the 3161 for public as it is still under regression testing . It may be out anytime but they are giving it on request. Ofcourse ,3152 is available for download. Thanks

Yes it is not available for general public, it is mentioned in the KB article mentioned above and below…. Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is available
http://support.microsoft.com/kb/935356
How to obtain the cumulative update package (build 3161) for SQL Server 2005 SP2
A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that is described in this article. Apply it only to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next SQL Server 2005 service pack that contains this hotfix. To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support http://support.microsoft.com/contactus/?ws=support) MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I’m sure this was available for download even though it says particular issue mentioned on the KBA, as I have downloaded without any special requirement. Let me check again. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>