FIX: AWE and SQL Server 2000 SP4 (899761)

FIX: Not all memory is available when AWE is enabled on a computer that is
running a 32-bit version of SQL Server 2000 SP4 (899761)
http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
This issue only impacts customers with more than 2GB of memory (available
only with the Enterprise, Developer and Evaluation editions) where AWE has
been enabled and more than half of the total system memory is being
allocated to a single SQL Server instance.
Customers with this configuration should apply this hotfix after upgrading
to SQL Server 2000 Service Pack 4.
KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.orgThanks Jasper.
Is there any central resouce for sql server hot fixes?
Paul
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4 (899761)
> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
> This issue only impacts customers with more than 2GB of memory (available
> only with the Enterprise, Developer and Evaluation editions) where AWE has
> been enabled and more than half of the total system memory is being
> allocated to a single SQL Server instance.
> Customers with this configuration should apply this hotfix after upgrading
> to SQL Server 2000 Service Pack 4.
> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>|||Hi
For a list, you can find it here.
http://www.aspfaq.com/show.asp?id=2160
For some reason, it has not been updated to the latest fixes yet.
Cheers
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul Cahill" <nospam@.hotmail.com> wrote in message
news:Oyu$31QdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Thanks Jasper.
> Is there any central resouce for sql server hot fixes?
> Paul
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
>> FIX: Not all memory is available when AWE is enabled on a computer that
>> is running a 32-bit version of SQL Server 2000 SP4 (899761)
>> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
>> This issue only impacts customers with more than 2GB of memory (available
>> only with the Enterprise, Developer and Evaluation editions) where AWE
>> has been enabled and more than half of the total system memory is being
>> allocated to a single SQL Server instance.
>> Customers with this configuration should apply this hotfix after
>> upgrading to SQL Server 2000 Service Pack 4.
>> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>|||Thanks Mike.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:euYYVbRdFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> For a list, you can find it here.
> http://www.aspfaq.com/show.asp?id=2160
> For some reason, it has not been updated to the latest fixes yet.
> Cheers
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul Cahill" <nospam@.hotmail.com> wrote in message
> news:Oyu$31QdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Thanks Jasper.
>> Is there any central resouce for sql server hot fixes?
>> Paul
>> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>> news:%23VwCMVMdFHA.412@.tk2msftngp13.phx.gbl...
>> FIX: Not all memory is available when AWE is enabled on a computer that
>> is running a 32-bit version of SQL Server 2000 SP4 (899761)
>> http://www.microsoft.com/downloads/details.aspx?familyid=7c407047-3f1f-48b8-9e4c-dc32875e1961&displaylang=en
>> This issue only impacts customers with more than 2GB of memory
>> (available only with the Enterprise, Developer and Evaluation editions)
>> where AWE has been enabled and more than half of the total system memory
>> is being allocated to a single SQL Server instance.
>> Customers with this configuration should apply this hotfix after
>> upgrading to SQL Server 2000 Service Pack 4.
>> KB 899761 http://support.microsoft.com/default.aspx?scid=KB;en-us;899761
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>>
>|||Mike Epprecht (SQL MVP) wrote:
> For a list, you can find it here:
> http://www.aspfaq.com/show.asp=AD?id=3D2160
> For some reason, it has not been updated to the latest fixes yet.
An updated list, containing only the build numbers for SQL Server 2000,
can be found at:
http://www.aspfaq.com/sql2000builds.asp
Razvan

First Time Installation of SQL Server 2005 Developer Edition

Just placed the SQL Server 2005 - Developer Edition into my Drive...

I get prompted with the following options..



This DVD contains 32-bit (x86) and 64-bit versions of this edition of SQL Server 2005. Click the link that matches your environment to begin



x86-based operating systems

x64-based operating systems

Itanuim-based operating syystems



I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...



I will be installing it on my PC... i



Microsoft Windows XP - Home Edition - Version 2 - Service Pack 2



My local Hard Drive remaining capacity is 12.6GB

External Hard Drive remaining capacity is 11.0GB



Tried looking everywhere for the answer... lol (even looked at YouTube for a simple installation video...





Thanks for your helpWindowx XP Home Edition is a 32 bit operating system. You want the X86 code for use on XP Home Edition.

-PatP|||I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...

As I only need to install the basic feature...

which one should i click?

SQL Server Database Services
Create a SQL Server fallover cluster
Analysus Services
Create an Analysis Server fallover cluster
Notification Services
Integration Services
Workstation components, Books Online development tools

Please help...|||On the Service Account section...

What should I click / Enter?

Username
Password
Domain

Under the... "Start Services at the end of setup" section, what should I tick?

SQL Server (tick already placed)
SQL Server Agent
SQL Brower

http://img.photobucket.com/albums/v675/akhlaq768/ServiceAccount.jpg

Many thanks