Microsoft Knowledge Base Article - 311111 Question

SQL 7.0 intermittently throws connection errors, the above
KB article seems to describe them.
Do I read the "FIX" correctly, that I should install SP1
for SQL2000 on my machine running SQL7.0?
Didn't make sense to me...
TIA
If you read the article more closely, you'll see that there is a recommended action for both SQL2K and for
SQL7.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tony" <awr@.shaw.ca> wrote in message news:ab5201c436ad$7afb53f0$a401280a@.phx.gbl...
> SQL 7.0 intermittently throws connection errors, the above
> KB article seems to describe them.
> Do I read the "FIX" correctly, that I should install SP1
> for SQL2000 on my machine running SQL7.0?
> Didn't make sense to me...
> TIA

Microsoft Knowledge Base Article - 311111 Question

SQL 7.0 intermittently throws connection errors, the above
KB article seems to describe them.
Do I read the "FIX" correctly, that I should install SP1
for SQL2000 on my machine running SQL7.0?
Didn't make sense to me...
TIAIf you read the article more closely, you'll see that there is a recommended
action for both SQL2K and for
SQL7.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tony" <awr@.shaw.ca> wrote in message news:ab5201c436ad$7afb53f0$a401280a@.phx.gbl...eagreen">
> SQL 7.0 intermittently throws connection errors, the above
> KB article seems to describe them.
> Do I read the "FIX" correctly, that I should install SP1
> for SQL2000 on my machine running SQL7.0?
> Didn't make sense to me...
> TIAsql

Microsoft Knowledge Base Article - 311111 Question

SQL 7.0 intermittently throws connection errors, the above
KB article seems to describe them.
Do I read the "FIX" correctly, that I should install SP1
for SQL2000 on my machine running SQL7.0?
Didn't make sense to me...
TIAIf you read the article more closely, you'll see that there is a recommended action for both SQL2K and for
SQL7.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tony" <awr@.shaw.ca> wrote in message news:ab5201c436ad$7afb53f0$a401280a@.phx.gbl...
> SQL 7.0 intermittently throws connection errors, the above
> KB article seems to describe them.
> Do I read the "FIX" correctly, that I should install SP1
> for SQL2000 on my machine running SQL7.0?
> Didn't make sense to me...
> TIA

Microsoft Knowledge Base Article - 274750

The Microsoft Knowledge Base Article - 274750 refers to
using AWE to increase the amount of memory SQL Server 2000
Enterprise and Developer editions will use.
We are using SQL Server 2000 standard on a Windows 2000
advanced server with 6 gb of ram. Does this KB article
apply to the standard editions as well?SQL2000 Standard won't use more than 2 GB. You need Enterprise Edition to
use more
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mike" <mkb@.burrwolff.com> wrote in message
news:3e6801c37608$b233c8e0$a001280a@.phx.gbl...
The Microsoft Knowledge Base Article - 274750 refers to
using AWE to increase the amount of memory SQL Server 2000
Enterprise and Developer editions will use.
We are using SQL Server 2000 standard on a Windows 2000
advanced server with 6 gb of ram. Does this KB article
apply to the standard editions as well?

Microsft Fix for wrong SP

Hi!
Tried to cure a problem described here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328551&Product=sql
The article says that
quote:
----
Hotfix 8.00.0702
A supported fix is now available from Microsoft, but it is only
intended to correct the problem described in this article. Only apply
it to systems that are experiencing this specific problem. This fix
may receive additional testing to further ensure product quality.
Therefore, if you are not severely affected by this problem, Microsoft
recommends that you wait for the next Microsoft SQL Server 2000
service pack (sp4) that contains this fix.
----
So I should be able to apply this fix for MS SQL2000 SP3. I could not
do it: It says that I have wrong service pack or version... Why?
Thanks."Roust_m" <roustam@.hotbox.ru> wrote in message
news:a388fd78.0311120254.3a5323ad@.posting.google.com...
> Tried to cure a problem described here:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328551&Product=sql
> The article says that
> quote:
> ----
--
> Hotfix 8.00.0702
> A supported fix is now available from Microsoft, but it is only
> intended to correct the problem described in this article. Only apply
> it to systems that are experiencing this specific problem. This fix
> may receive additional testing to further ensure product quality.
> Therefore, if you are not severely affected by this problem, Microsoft
> recommends that you wait for the next Microsoft SQL Server 2000
> service pack (sp4) that contains this fix.
> ----
--
> So I should be able to apply this fix for MS SQL2000 SP3. I could not
> do it: It says that I have wrong service pack or version... Why?
It's possible you need to apply the latest service pack which is SQL Server
2000 SP3a , then apply the hotfix.
Steve|||This hotfix is a pre-SP3 hotfix. Build number 702 is prior to SP3 build of
760. This hotfix cannot be applied to SQL Server 2000 SP3. You will need
hotfix build 765 to get the fix for SP3.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||- So, what SP matches this service pack, 1st or 2nd?
(I could not install it on MS SQL2000 w/o SP too)
rboyd@.onlinemicrosoft.com (Rand Boyd [MS]) wrote in message news:<uOuMCDYqDHA.1548@.cpmsftngxa06.phx.gbl>...
> This hotfix is a pre-SP3 hotfix. Build number 702 is prior to SP3 build of
> 760. This hotfix cannot be applied to SQL Server 2000 SP3. You will need
> hotfix build 765 to get the fix for SP3.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.|||"Roust_m" <roustam@.hotbox.ru> wrote in message
news:a388fd78.0311140139.49eb3fc0@.posting.google.com...
> - So, what SP matches this service pack, 1st or 2nd?
> (I could not install it on MS SQL2000 w/o SP too)
If you mean which service patch would match that hotfix -- the hotfix should
work on a post SP2 SQL installation.
For version information
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185&Product=sql
I'd recommend getting the post sp3 hotfix and installing SQL Server SP3a.
Steve
> rboyd@.onlinemicrosoft.com (Rand Boyd [MS]) wrote in message
news:<uOuMCDYqDHA.1548@.cpmsftngxa06.phx.gbl>...
> > This hotfix is a pre-SP3 hotfix. Build number 702 is prior to SP3 build
of
> > 760. This hotfix cannot be applied to SQL Server 2000 SP3. You will need
> > hotfix build 765 to get the fix for SP3.
> >
> > Rand
> > This posting is provided "as is" with no warranties and confers no
rights.|||You need to contact Microsoft and get the post-SP3 hotfix.
Rand
This posting is provided "as is" with no warranties and confers no rights.