Explanation

Can anyone explain me this:
""
Your company has recently purchased a new 64-bit SQL
Server 2000 machine with 8 GB of RAM. You are confused
about which of the PAE and AWE settings should be enabled.
How should you configure Windows and SQL Server to utilize
the 8GB of RAM?
""
Can anyone explain me what PAE and AWE settings are?
Thanxs
Both of these are documented in Books Online. I suggest you download the updated version of Books Online,
though:
http://www.microsoft.com/SQL/techinf...00/default.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"claudy" <anonymous@.discussions.microsoft.com> wrote in message news:202d01c42777$e36d5040$a401280a@.phx.gbl...
> Can anyone explain me this:
> ""
> Your company has recently purchased a new 64-bit SQL
> Server 2000 machine with 8 GB of RAM. You are confused
> about which of the PAE and AWE settings should be enabled.
> How should you configure Windows and SQL Server to utilize
> the 8GB of RAM?
> ""
> Can anyone explain me what PAE and AWE settings are?
> Thanxs
>

Explanation

Can anyone explain me this:
""
Your company has recently purchased a new 64-bit SQL
Server 2000 machine with 8 GB of RAM. You are confused
about which of the PAE and AWE settings should be enabled.
How should you configure Windows and SQL Server to utilize
the 8GB of RAM?
""
Can anyone explain me what PAE and AWE settings are?
ThanxsBoth of these are documented in Books Online. I suggest you download the updated version of Books Online,
though:
http://www.microsoft.com/SQL/techinfo/productdoc/2000/default.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"claudy" <anonymous@.discussions.microsoft.com> wrote in message news:202d01c42777$e36d5040$a401280a@.phx.gbl...
> Can anyone explain me this:
> ""
> Your company has recently purchased a new 64-bit SQL
> Server 2000 machine with 8 GB of RAM. You are confused
> about which of the PAE and AWE settings should be enabled.
> How should you configure Windows and SQL Server to utilize
> the 8GB of RAM?
> ""
> Can anyone explain me what PAE and AWE settings are?
> Thanxs
>|||http://www.microsoft.com/sql/64bit/productinfo/SQL64bitAdva
ntages.asp
http://www.microsoft.com/windows2000/en/advanced/help/defau
lt.asp?url=/windows2000/en/advanced/help/paex86_1.htm
>--Original Message--
>Can anyone explain me this:
>""
>Your company has recently purchased a new 64-bit SQL
>Server 2000 machine with 8 GB of RAM. You are confused
>about which of the PAE and AWE settings should be
enabled.
>How should you configure Windows and SQL Server to
utilize
>the 8GB of RAM?
>""
>Can anyone explain me what PAE and AWE settings are?
>Thanxs
>.
>

Explanation

Can anyone explain me this:
""
Your company has recently purchased a new 64-bit SQL
Server 2000 machine with 8 GB of RAM. You are confused
about which of the PAE and AWE settings should be enabled.
How should you configure Windows and SQL Server to utilize
the 8GB of RAM?
""
Can anyone explain me what PAE and AWE settings are?
ThanxsBoth of these are documented in Books Online. I suggest you download the upd
ated version of Books Online,
though:
http://www.microsoft.com/SQL/techin...000/default.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"claudy" <anonymous@.discussions.microsoft.com> wrote in message news:202d01c42777$e36d5040$a
401280a@.phx.gbl...
> Can anyone explain me this:
> ""
> Your company has recently purchased a new 64-bit SQL
> Server 2000 machine with 8 GB of RAM. You are confused
> about which of the PAE and AWE settings should be enabled.
> How should you configure Windows and SQL Server to utilize
> the 8GB of RAM?
> ""
> Can anyone explain me what PAE and AWE settings are?
> Thanxs
>

Expand/Collapse works from VS but not from IE

I am using Reporting Services with SP2; SQL Server 2000 with SP4; Windows
2003 Server; 1GB freespace and 1GB RAM.
Previewing my report in either IE (ReportServer) or Visual Studio, the
expand and collapse on my drillthrough works just fine. I can export to
Excel from Visual Studio's preview tab and get all the levels of my
drillthrough to work just fine. However, exporting to Excel from IE only
gives me the first two levels of drillthrough (I have 5 in this particular
report) -- I get the same 2 levels when I immediately export to Excel from
the RS menu bar or run this as a timed subscription.
Is there a buffer issue or something I can configure in Reporting Services
that will allow it to export all 5 levels to Excel?After toying around with the Properties in ReportServer I found that setting
the report's Properties | Execution | Report Execution Timeout to "Do not
timeout report execution" fixed the problem. I have been able to get all
levels of expansion to export to Excel from IE.
"bhc" wrote:
> I am using Reporting Services with SP2; SQL Server 2000 with SP4; Windows
> 2003 Server; 1GB freespace and 1GB RAM.
> Previewing my report in either IE (ReportServer) or Visual Studio, the
> expand and collapse on my drillthrough works just fine. I can export to
> Excel from Visual Studio's preview tab and get all the levels of my
> drillthrough to work just fine. However, exporting to Excel from IE only
> gives me the first two levels of drillthrough (I have 5 in this particular
> report) -- I get the same 2 levels when I immediately export to Excel from
> the RS menu bar or run this as a timed subscription.
> Is there a buffer issue or something I can configure in Reporting Services
> that will allow it to export all 5 levels to Excel?