Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

AWE and the SP4...
When the SQL Server SP4 was released I was informed it had some issues with
AWE.

Is those issues are still exist? Is it safe to installs SP4?  My SQL Server
installation left with default AWE settings (value of 0).  Since AWE is not
enabled, applying SP4 should not be any issue in my case.

Thanks,

Larry



Report this thread to moderator Post Follow-up to this message
Old Post
Larry Smith
10-01-05 01:23 AM


Re: AWE and the SP4...
Hi

No problem for you. You do not have to apply the patch to bring you to
version 2040 from 2039

Regards
--------------------------------
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/

"Larry Smith" < LSmith_Melbourne@hot
mail.com> wrote in message
news:O0GnXdgxFHA.2136@TK2MSFTNGP10.phx.gbl...
> When the SQL Server SP4 was released I was informed it had some issues
> with
> AWE.
>
> Is those issues are still exist? Is it safe to installs SP4?  My SQL
> Server
> installation left with default AWE settings (value of 0).  Since AWE is
> not
> enabled, applying SP4 should not be any issue in my case.
>
> Thanks,
>
> Larry
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Mike Epprecht \(SQL MVP\)
10-01-05 01:23 AM


Re: AWE and the SP4...
You are suggesting that I can live without SP4?
See the link below what Microsoft  says.....
http://www.microsoft.com/sql/techin...
er.mspx
This link prompted me to apply the SP4.
What is version 2039/2040? My SQL Server installation says 8.00.760
??
Thank you,
Larry


"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:Oj%23tNugxFHA.2212@TK2MSFTNGP15.phx.gbl...
> Hi
>
> No problem for you. You do not have to apply the patch to bring you to
> version 2040 from 2039
>
> Regards
> --------------------------------
> 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/
>
> "Larry Smith" < LSmith_Melbourne@hot
mail.com> wrote in message
> news:O0GnXdgxFHA.2136@TK2MSFTNGP10.phx.gbl... 
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Larry Smith
10-01-05 01:23 AM


Re: AWE and the SP4...
Hi

No. Apply SP4, but if you are not using AWE memory, you do not have to apply
the hotfix to SP4 to fix the AWE memory issue.

8.00.2039 = SP4

You currently have SP3 installed.

Regards
--------------------------------
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/

"Larry Smith" < LSmith_Melbourne@hot
mail.com> wrote in message
news:e67oU$gxFHA.3300@TK2MSFTNGP09.phx.gbl...
> You are suggesting that I can live without SP4?
> See the link below what Microsoft  says.....
> http://www.microsoft.com/sql/techin...r />
rver.mspx
> This link prompted me to apply the SP4.
> What is version 2039/2040? My SQL Server installation says 8.00.760
> ??
> Thank you,
> Larry
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:Oj%23tNugxFHA.2212@TK2MSFTNGP15.phx.gbl... 
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Mike Epprecht \(SQL MVP\)
10-01-05 01:23 AM


Re: AWE and the SP4...
Thank you for the suggestion.
How did you derive the equation "8.00.2039 = SP4" ?
Thank you,
Larry


"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:%23u786BhxFHA.3188@TK2MSFTNGP14.phx.gbl...
> Hi
>
> No. Apply SP4, but if you are not using AWE memory, you do not have to
 apply

> the hotfix to SP4 to fix the AWE memory issue.
>
> 8.00.2039 = SP4
>
> You currently have SP3 installed.
>
> Regards
> --------------------------------
> 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/
>
> "Larry Smith" < LSmith_Melbourne@hot
mail.com> wrote in message
> news:e67oU$gxFHA.3300@TK2MSFTNGP09.phx.gbl... 
http://www.microsoft.com/sql/techin...gsqlserver.mspx[c
olor=darkred] 
 issues[color=darkred
] 
is 
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Larry Smith
10-01-05 01:23 AM


Re: AWE and the SP4...
Hi

The outdated list http://www.aspfaq.com/show.asp?id=2160 and
http://support.microsoft.com/defaul...kb;en-us;321185 and from
installing it and looking at the version numbers.

Regards
--------------------------------
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/

"Larry Smith" < LSmith_Melbourne@hot
mail.com> wrote in message
news:OaYHIGhxFHA.2728@TK2MSFTNGP14.phx.gbl...
> Thank you for the suggestion.
> How did you derive the equation "8.00.2039 = SP4" ?
> Thank you,
> Larry
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:%23u786BhxFHA.3188@TK2MSFTNGP14.phx.gbl... 
> apply 
> http://www.microsoft.com/sql/techin...r />
rver.mspx 
> issues 
> is 
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Mike Epprecht \(SQL MVP\)
10-01-05 01:23 AM


Re: AWE and the SP4...
Thank you,
Larry

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:epVvHNhxFHA.3236@TK2MSFTNGP14.phx.gbl...
> Hi
>
> The outdated list http://www.aspfaq.com/show.asp?id=2160 and
> http://support.microsoft.com/defaul...kb;en-us;321185 and from
> installing it and looking at the version numbers.
>
> Regards
> --------------------------------
> 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/
>
> "Larry Smith" < LSmith_Melbourne@hot
mail.com> wrote in message
> news:OaYHIGhxFHA.2728@TK2MSFTNGP14.phx.gbl... 
http://www.microsoft.com/sql/techin...gsqlserver.mspx[c
olor=darkred] 
to 
SQL 
AWE 
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Larry Smith
10-01-05 01:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 02:28 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006