Re: SQL Server 2000 SP4 - realease date

Anthony,

How can I get the Q821334 Hotfix
I search the microsoft site and I could not find it.
Thanks,
Ayman M. Abd-El Salam

"Anthony Thomas" wrote:

> From the webcast last week, it looks like SP4 is targeted for the first ha
lf
> of 2005.  That being said, there is no "fix" with UMS non-yielding process
es
> on scheduler threads.  SP3 just provided more "server health" notification
s.
> However, there are at least three publicly available, post SP3a hotfixes y
ou
> could download that could assist with some contention issues that may be
> driving the non-yielding nature of your problem.
>
> As other posters have indicated, MS PSS would be better suited to diagnose
> your issue.
>
> That being said, take a look at the following KB for what you are discribi
ng
> as well as the links to the public hotfixes I mentioned.
>
> New concurrency and scheduling diagnostics added to SQL Server:
> http://support.microsoft.com/defaul...kb;en-us;319892
>
> SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a:
> http://support.microsoft.com/defaul...kb;en-us;810185
>
> Build 80.00.0818:
>
> SQL Server 2000 (32-bit) Security Patch MS03-031:
> http://www.microsoft.com/downloads/...&displaylang=en
>
> Build 80.00.0819:
>
> FIX: You are prompted for password confirmation after you change a standar
d
> SQL Server login:
> http://support.microsoft.com/default.aspx?scid=kb;[LN];Q826161
>
> Build 80.00.0859:
>
> FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859:
> http://support.microsoft.com/default.aspx?scid=kb;[LN];Q821334
>
> Build 80.00.0878:
>
> You must install the SQL Server 2000 update that KB article 831950 describ
es
> to run BizTalk Server 2004: http://support.microsoft.com/?kbid=838166
>
> Keep in mind that SQL Server hot fix builds are cumulative and contain all
> fixes, public and private, that have preceeded it.  So, for instance, if y
ou
> install the latest publicly available hot fix build, 878, then looking at
> article KB 810185 will tell you all the bugs and fixes contained within th
is
> build post SP3a.  If any of these look like they may help your situation,
> applying this build may assist.
>
> Also keep in mind that 967 is the current private available build and that
> 878 itself may introduce issues between these two builds, which is also
> listed in KB 810185.
>
> SP4 is what I am after also, but, I also have production issues TODAY that
> need to be addressed; so, we run 878 and for some installations, call MS P
SS
> to get the private build to fix that particular issue.
>
> You should also be apart of the Beta Testing program, which only helps all
> of us, and Microsoft find and fix additional bugs before release.
> http://www.microsoft.com/sql/evalua...nominations.asp
>
> Hope this helps.
>
> Sincerely,
>
>
> Anthony Thomas
>
> --
>
> "Dave Wall" < DaveWall@discussions
.microsoft.com> wrote in message
> news:DFC0A975-BA8F-48F5-A6E3- 500FAD99EBAF@microso
ft.com...
> Hi Guys,
>
> Anyone any idea when SQL Server 2k SP4 will be released?  We've got a
> problem with non-yeilding schedules that is "supposedly" fixed in SP4.
>
> Thanks in advance
> Dave
>
> --
> Dave Wall
>
>
>

AFAIK there is no public download for it. If your problem is concerned about
you producton system and you really need it, this would be a thing to
contact MS PSS to diagnose your issue.


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


"Ayman" <Ayman@discussions.microsoft.com> schrieb im Newsbeitrag
news:56EC9B6A-19C2-4D07-A124- 845EAD798A1E@microso
ft.com...
> Anthony,
>
> How can I get the Q821334 Hotfix
> I search the microsoft site and I could not find it.
> Thanks,
> Ayman M. Abd-El Salam
>
> "Anthony Thomas" wrote:
>