What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?
SQL Server 2000 SP3 ?Originally posted by Karolyn
What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?
SQL Server 2000 SP3 ? http://www.microsoft.com/sql/msde/downloads/download.asp|||you're early today !
happy new year !
Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?
'Cause I've done all my tests on SQL Server 7 and MSDE 7
and I was'nt impressed by the performances
(that we're comparable with thoses I had with Sybase)|||Originally posted by Karolyn
Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?
Cant comment much on that !! have not worked much on SQL Server 7.0|||Performance increases - New datatype(table), views (ability to index and partition), index enhancements such as ability to index a computed column and index creation, how text/ntext/image are stored ...
Read this article:
link (http://msdn.microsoft.com/msdnmag/issues/0800/sql2000/default.aspx)|||You left out UDFs?|||That was referencing performance increases - udfs offer reusability,maintainability and extensibility ... Anyway, all the benefits of sql server 2000 are included in the link.|||Also ... don't mention udfs for a while after the permissions bug :-)|||yeah, brett, you almost started it again|||Originally posted by rnealejr
Also ... don't mention udfs for a while after the permissions bug :-)
hey !!! what was that ??|||well, rdjabarov and blindman got at it again when an m$ bug was being discussed. apparently neither one of them can hold their waters :-)|||?? :confused: ??|||hey, it's simple:
one is a man, and another...is also a man...does it make sense?? :-)|||I mean ... can you point me to the battleground ... i would like to see the war for myself :D|||just read from the beginning (http://www.dbforums.com/t977030.html)
Showing posts with label version. Show all posts
Showing posts with label version. Show all posts
Wednesday, March 28, 2012
Latest version of Microsoft MBSA 1.1.1 says:
I would think that you would still want to remove the
BUILTIN\Administrators group from the sysadmin role even
on a client-only installation.
Many non-administrator users are often members of the
BULTIN\Administrators group on their own machines whether
they should be or not. These users would have the
ability to drop databases, truncate tables, etc., etc.
It may not be the most likely scenario, but stranger
things have happened...
Tim
be
has
local
login rights for it's service account, and if you use full-text make sure
[nt authority\system] has sysadmin rights....
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:023601c3d948$60021dd0$a401280a@.phx.gbl...[QUOTE]
> I would think that you would still want to remove the
> BUILTIN\Administrators group from the sysadmin role even
> on a client-only installation.
> Many non-administrator users are often members of the
> BULTIN\Administrators group on their own machines whether
> they should be or not. These users would have the
> ability to drop databases, truncate tables, etc., etc.
> It may not be the most likely scenario, but stranger
> things have happened...
> Tim
>
> be
> has
> local
BUILTIN\Administrators group from the sysadmin role even
on a client-only installation.
Many non-administrator users are often members of the
BULTIN\Administrators group on their own machines whether
they should be or not. These users would have the
ability to drop databases, truncate tables, etc., etc.
It may not be the most likely scenario, but stranger
things have happened...
Tim
quote:
>--Original Message--
>The latest MBSA (1.1.1) says
>"Issue
>Local Windows administrators should not also be SQL
>database administrators. These roles are very different
>and are typically performed by different people.
>Solution
>Remove BUILTIN\Administrators from the sysadmin role."
>This makes sense for a server. Does it make sense on a
>client machine?
>I am thinking this is necessary for the server that may
be
quote:
>shared in someway; however, if I am using a setup that
has
quote:
>DISABLENETWORKPROTOCOLS=1 (no access except from the
local
quote:Make sure, however that the SQL Server Agent service still has sysadmin
>host itself), I would think this does not apply.
>Does anyone know for sure?
>Giacomo
>.
>
login rights for it's service account, and if you use full-text make sure
[nt authority\system] has sysadmin rights....
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:023601c3d948$60021dd0$a401280a@.phx.gbl...[QUOTE]
> I would think that you would still want to remove the
> BUILTIN\Administrators group from the sysadmin role even
> on a client-only installation.
> Many non-administrator users are often members of the
> BULTIN\Administrators group on their own machines whether
> they should be or not. These users would have the
> ability to drop databases, truncate tables, etc., etc.
> It may not be the most likely scenario, but stranger
> things have happened...
> Tim
>
> be
> has
> local
Latest version of Microsoft MBSA 1.1.1 says:
The latest MBSA (1.1.1) says
"Issue
Local Windows administrators should not also be SQL
database administrators. These roles are very different
and are typically performed by different people.
Solution
Remove BUILTIN\Administrators from the sysadmin role."
This makes sense for a server. Does it make sense on a
client machine?
I am thinking this is necessary for the server that may be
shared in someway; however, if I am using a setup that has
DISABLENETWORKPROTOCOLS=1 (no access except from the local
host itself), I would think this does not apply.
Does anyone know for sure?
GiacomoGiacomo wrote:
> The latest MBSA (1.1.1) says
> "Issue
> Local Windows administrators should not also be SQL
> database administrators. These roles are very different
> and are typically performed by different people.
> Solution
> Remove BUILTIN\Administrators from the sysadmin role."
> This makes sense for a server. Does it make sense on a
> client machine?
> I am thinking this is necessary for the server that may be
> shared in someway; however, if I am using a setup that has
> DISABLENETWORKPROTOCOLS=1 (no access except from the local
> host itself), I would think this does not apply.
> Does anyone know for sure?
There is not much "for sure" in security issues, just which side of a
compromise makes the most sense for you.
For me, one of the most compelling reasons to do this on a local workstation
copy of SQL is that only my SQL developers have this, and both i and they
would want to mimic the conditions the live system they are developing for
runs under as much as possible.
We've had issues in the past where a, pardon me, less diligent developer who
has had admin rights to everything on their dev machine didn't bother coding
to take security into account so their code wouldn't run on a live system
without a lot of re-working.
"Issue
Local Windows administrators should not also be SQL
database administrators. These roles are very different
and are typically performed by different people.
Solution
Remove BUILTIN\Administrators from the sysadmin role."
This makes sense for a server. Does it make sense on a
client machine?
I am thinking this is necessary for the server that may be
shared in someway; however, if I am using a setup that has
DISABLENETWORKPROTOCOLS=1 (no access except from the local
host itself), I would think this does not apply.
Does anyone know for sure?
GiacomoGiacomo wrote:
> The latest MBSA (1.1.1) says
> "Issue
> Local Windows administrators should not also be SQL
> database administrators. These roles are very different
> and are typically performed by different people.
> Solution
> Remove BUILTIN\Administrators from the sysadmin role."
> This makes sense for a server. Does it make sense on a
> client machine?
> I am thinking this is necessary for the server that may be
> shared in someway; however, if I am using a setup that has
> DISABLENETWORKPROTOCOLS=1 (no access except from the local
> host itself), I would think this does not apply.
> Does anyone know for sure?
There is not much "for sure" in security issues, just which side of a
compromise makes the most sense for you.
For me, one of the most compelling reasons to do this on a local workstation
copy of SQL is that only my SQL developers have this, and both i and they
would want to mimic the conditions the live system they are developing for
runs under as much as possible.
We've had issues in the past where a, pardon me, less diligent developer who
has had admin rights to everything on their dev machine didn't bother coding
to take security into account so their code wouldn't run on a live system
without a lot of re-working.
latest hotfixes and SP3
Hello everyone
I am very new at this and I really need your help.
We have purchased and installed an SQL Server 2000, Product Version: 8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not supposed to install SP3a. My system is up-to-date regarding critical updates from widows update service.
Can anyone tell me what additional hotfixes for SQL do I have to install in order to keep my system healthy?
I am confused because I placed a query on the Microsoft Security Bulletin Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins that contain patches that have not been replaced by a more recent patch.) and the results I got were:
1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC 2.7, MDAC 2.8
2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495): MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE), Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
The first one (832483) is installed but the second is not. Does windows updates service install hotfixes for SQL Server or do I have to install them manually?
Do I have to install this Patch 815495?
Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A (This release includes the fixes for the Slammer (W32.slammer) worm)? (I found this on another page Most Popular Downloads)
Sorry for the length!
I thank you in advance for your time.
Don't install all of them that I can tell you. Only install the hotfixes if
you realy realy realy need them. I did install them all and it caused me
more trouble than it did good. Just wait patiently for SP4, I guess that's
much safer.
mvg
Michael
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>
|||Hi,
If the issues in MS03-031 are applicable to you then apply MS03-031 with
826161 (this fixes a problem from MS03-031). This is the level we are aiming
at. Also SP4 should not be too long from now.
Chris Wood
Alberta Department of Energy
CANADA
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>
|||I am new to SQL Server and have SQL Server 2000 SP3
running on Windows 2000. We are experiencing some
performance problems and I am considering applying SP3a.
I noticed in you question that you stated "I understand
that I am not supposed to install SP3a." why did you say
this, I could not find anything in the documents about
SP3a that would supoort this?
Thanks, Phil
>--Original Message--
>Don't install all of them that I can tell you. Only
install the hotfixes if
>you realy realy realy need them. I did install them all
and it caused me
>more trouble than it did good. Just wait patiently for
SP4, I guess that's
>much safer.
>mvg
>Michael
>"bonset" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0BAB4516-FE3F-4491-B619-
24EEF364BC96@.microsoft.com...[vbcol=seagreen]
Product Version:
>8.00.760 (SP3) in a new Windows 2003 Server. I
understand that I am not
>supposed to install SP3a. My system is up-to-date
regarding critical updates[vbcol=seagreen]
>from widows update service.
I have to install[vbcol=seagreen]
>in order to keep my system healthy?
Microsoft Security Bulletin
>Search Page for SQL Server 2000 (SP3) hotfixes (checked:
Show only bulletins
>that contain patches that have not been replaced by a
more recent patch.)[vbcol=seagreen]
>and the results I got were:
Could Allow Code
>Execution (832483): MS04-003, Affected Software: MDAC
2.5, MDAC 2.6, MDAC[vbcol=seagreen]
>2.7, MDAC 2.8
Server (815495):
>MS03-031, Affected Software: SQL Server 7.0, Microsoft
Data Engine (MSDE),
>Microsoft SQL Server 2000 Desktop Engine (MSDE 2000),
SQL Server 2000[vbcol=seagreen]
not. Does windows
>updates service install hotfixes for SQL Server or do I
have to install them[vbcol=seagreen]
>manually?
Engine (MSDE 2000)
>Release A (This release includes the fixes for the
Slammer (W32.slammer)
>worm)? (I found this on another page Most Popular
Downloads)
>
>.
>
I am very new at this and I really need your help.
We have purchased and installed an SQL Server 2000, Product Version: 8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not supposed to install SP3a. My system is up-to-date regarding critical updates from widows update service.
Can anyone tell me what additional hotfixes for SQL do I have to install in order to keep my system healthy?
I am confused because I placed a query on the Microsoft Security Bulletin Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins that contain patches that have not been replaced by a more recent patch.) and the results I got were:
1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC 2.7, MDAC 2.8
2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495): MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE), Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
The first one (832483) is installed but the second is not. Does windows updates service install hotfixes for SQL Server or do I have to install them manually?
Do I have to install this Patch 815495?
Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A (This release includes the fixes for the Slammer (W32.slammer) worm)? (I found this on another page Most Popular Downloads)
Sorry for the length!
I thank you in advance for your time.
Don't install all of them that I can tell you. Only install the hotfixes if
you realy realy realy need them. I did install them all and it caused me
more trouble than it did good. Just wait patiently for SP4, I guess that's
much safer.
mvg
Michael
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>
|||Hi,
If the issues in MS03-031 are applicable to you then apply MS03-031 with
826161 (this fixes a problem from MS03-031). This is the level we are aiming
at. Also SP4 should not be too long from now.
Chris Wood
Alberta Department of Energy
CANADA
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>
|||I am new to SQL Server and have SQL Server 2000 SP3
running on Windows 2000. We are experiencing some
performance problems and I am considering applying SP3a.
I noticed in you question that you stated "I understand
that I am not supposed to install SP3a." why did you say
this, I could not find anything in the documents about
SP3a that would supoort this?
Thanks, Phil
>--Original Message--
>Don't install all of them that I can tell you. Only
install the hotfixes if
>you realy realy realy need them. I did install them all
and it caused me
>more trouble than it did good. Just wait patiently for
SP4, I guess that's
>much safer.
>mvg
>Michael
>"bonset" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0BAB4516-FE3F-4491-B619-
24EEF364BC96@.microsoft.com...[vbcol=seagreen]
Product Version:
>8.00.760 (SP3) in a new Windows 2003 Server. I
understand that I am not
>supposed to install SP3a. My system is up-to-date
regarding critical updates[vbcol=seagreen]
>from widows update service.
I have to install[vbcol=seagreen]
>in order to keep my system healthy?
Microsoft Security Bulletin
>Search Page for SQL Server 2000 (SP3) hotfixes (checked:
Show only bulletins
>that contain patches that have not been replaced by a
more recent patch.)[vbcol=seagreen]
>and the results I got were:
Could Allow Code
>Execution (832483): MS04-003, Affected Software: MDAC
2.5, MDAC 2.6, MDAC[vbcol=seagreen]
>2.7, MDAC 2.8
Server (815495):
>MS03-031, Affected Software: SQL Server 7.0, Microsoft
Data Engine (MSDE),
>Microsoft SQL Server 2000 Desktop Engine (MSDE 2000),
SQL Server 2000[vbcol=seagreen]
not. Does windows
>updates service install hotfixes for SQL Server or do I
have to install them[vbcol=seagreen]
>manually?
Engine (MSDE 2000)
>Release A (This release includes the fixes for the
Slammer (W32.slammer)
>worm)? (I found this on another page Most Popular
Downloads)
>
>.
>
latest hotfixes and SP3
Hello everyone
I am very new at this and I really need your help.
We have purchased and installed an SQL Server 2000, Product Version: 8.00.76
0 (SP3) in a new Windows 2003 Server. I understand that I am not supposed to
install SP3a. My system is up-to-date regarding critical updates from widow
s update service.
Can anyone tell me what additional hotfixes for SQL do I have to install in
order to keep my system healthy?
I am confused because I placed a query on the Microsoft Security Bulletin Se
arch Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins t
hat contain patches that have not been replaced by a more recent patch.) and
the results I got were:
1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code Execution
(832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC 2.7, MDAC 2
.8
2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495): MS03-03
1, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE), Microsof
t SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
The first one (832483) is installed but the second is not. Does windows upda
tes service install hotfixes for SQL Server or do I have to install them man
ually?
Do I have to install this Patch 815495?
Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Re
lease A (This release includes the fixes for the Slammer (W32.slammer) worm)
? (I found this on another page Most Popular Downloads)
Sorry for the length!
I thank you in advance for your time.Don't install all of them that I can tell you. Only install the hotfixes if
you realy realy realy need them. I did install them all and it caused me
more trouble than it did good. Just wait patiently for SP4, I guess that's
much safer.
mvg
Michael
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||Hi,
If the issues in MS03-031 are applicable to you then apply MS03-031 with
826161 (this fixes a problem from MS03-031). This is the level we are aiming
at. Also SP4 should not be too long from now.
Chris Wood
Alberta Department of Energy
CANADA
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||I am new to SQL Server and have SQL Server 2000 SP3
running on Windows 2000. We are experiencing some
performance problems and I am considering applying SP3a.
I noticed in you question that you stated "I understand
that I am not supposed to install SP3a." why did you say
this, I could not find anything in the documents about
SP3a that would supoort this?
Thanks, Phil
>--Original Message--
>Don't install all of them that I can tell you. Only
install the hotfixes if
>you realy realy realy need them. I did install them all
and it caused me
>more trouble than it did good. Just wait patiently for
SP4, I guess that's
>much safer.
>mvg
>Michael
>"bonset" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0BAB4516-FE3F-4491-B619-
24EEF364BC96@.microsoft.com...
Product Version:[vbcol=seagreen]
>8.00.760 (SP3) in a new Windows 2003 Server. I
understand that I am not
>supposed to install SP3a. My system is up-to-date
regarding critical updates
>from widows update service.
I have to install[vbcol=seagreen]
>in order to keep my system healthy?
Microsoft Security Bulletin[vbcol=seagreen]
>Search Page for SQL Server 2000 (SP3) hotfixes (checked:
Show only bulletins
>that contain patches that have not been replaced by a
more recent patch.)
>and the results I got were:
Could Allow Code[vbcol=seagreen]
>Execution (832483): MS04-003, Affected Software: MDAC
2.5, MDAC 2.6, MDAC
>2.7, MDAC 2.8
Server (815495):[vbcol=seagreen]
>MS03-031, Affected Software: SQL Server 7.0, Microsoft
Data Engine (MSDE),
>Microsoft SQL Server 2000 Desktop Engine (MSDE 2000),
SQL Server 2000
not. Does windows[vbcol=seagreen]
>updates service install hotfixes for SQL Server or do I
have to install them
>manually?
Engine (MSDE 2000)[vbcol=seagreen]
>Release A (This release includes the fixes for the
Slammer (W32.slammer)
>worm)? (I found this on another page Most Popular
Downloads)
>
>.
>
I am very new at this and I really need your help.
We have purchased and installed an SQL Server 2000, Product Version: 8.00.76
0 (SP3) in a new Windows 2003 Server. I understand that I am not supposed to
install SP3a. My system is up-to-date regarding critical updates from widow
s update service.
Can anyone tell me what additional hotfixes for SQL do I have to install in
order to keep my system healthy?
I am confused because I placed a query on the Microsoft Security Bulletin Se
arch Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins t
hat contain patches that have not been replaced by a more recent patch.) and
the results I got were:
1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code Execution
(832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC 2.7, MDAC 2
.8
2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495): MS03-03
1, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE), Microsof
t SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
The first one (832483) is installed but the second is not. Does windows upda
tes service install hotfixes for SQL Server or do I have to install them man
ually?
Do I have to install this Patch 815495?
Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Re
lease A (This release includes the fixes for the Slammer (W32.slammer) worm)
? (I found this on another page Most Popular Downloads)
Sorry for the length!
I thank you in advance for your time.Don't install all of them that I can tell you. Only install the hotfixes if
you realy realy realy need them. I did install them all and it caused me
more trouble than it did good. Just wait patiently for SP4, I guess that's
much safer.
mvg
Michael
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||Hi,
If the issues in MS03-031 are applicable to you then apply MS03-031 with
826161 (this fixes a problem from MS03-031). This is the level we are aiming
at. Also SP4 should not be too long from now.
Chris Wood
Alberta Department of Energy
CANADA
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||I am new to SQL Server and have SQL Server 2000 SP3
running on Windows 2000. We are experiencing some
performance problems and I am considering applying SP3a.
I noticed in you question that you stated "I understand
that I am not supposed to install SP3a." why did you say
this, I could not find anything in the documents about
SP3a that would supoort this?
Thanks, Phil
>--Original Message--
>Don't install all of them that I can tell you. Only
install the hotfixes if
>you realy realy realy need them. I did install them all
and it caused me
>more trouble than it did good. Just wait patiently for
SP4, I guess that's
>much safer.
>mvg
>Michael
>"bonset" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0BAB4516-FE3F-4491-B619-
24EEF364BC96@.microsoft.com...
Product Version:[vbcol=seagreen]
>8.00.760 (SP3) in a new Windows 2003 Server. I
understand that I am not
>supposed to install SP3a. My system is up-to-date
regarding critical updates
>from widows update service.
I have to install[vbcol=seagreen]
>in order to keep my system healthy?
Microsoft Security Bulletin[vbcol=seagreen]
>Search Page for SQL Server 2000 (SP3) hotfixes (checked:
Show only bulletins
>that contain patches that have not been replaced by a
more recent patch.)
>and the results I got were:
Could Allow Code[vbcol=seagreen]
>Execution (832483): MS04-003, Affected Software: MDAC
2.5, MDAC 2.6, MDAC
>2.7, MDAC 2.8
Server (815495):[vbcol=seagreen]
>MS03-031, Affected Software: SQL Server 7.0, Microsoft
Data Engine (MSDE),
>Microsoft SQL Server 2000 Desktop Engine (MSDE 2000),
SQL Server 2000
not. Does windows[vbcol=seagreen]
>updates service install hotfixes for SQL Server or do I
have to install them
>manually?
Engine (MSDE 2000)[vbcol=seagreen]
>Release A (This release includes the fixes for the
Slammer (W32.slammer)
>worm)? (I found this on another page Most Popular
Downloads)
>
>.
>
latest hotfixes and SP3
Hello everyon
I am very new at this and I really need your help.
We have purchased and installed an SQL Server 2000, Product Version: 8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not supposed to install SP3a. My system is up-to-date regarding critical updates from widows update service.
Can anyone tell me what additional hotfixes for SQL do I have to install in order to keep my system healthy?
I am confused because I placed a query on the Microsoft Security Bulletin Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins that contain patches that have not been replaced by a more recent patch.) and the results I got were
1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC 2.7, MDAC 2.8
2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495): MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE), Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 200
The first one (832483) is installed but the second is not. Does windows updates service install hotfixes for SQL Server or do I have to install them manually?
Do I have to install this Patch 815495?
Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A (This release includes the fixes for the Slammer (W32.slammer) worm)? (I found this on another page Most Popular Downloads
Sorry for the length
I thank you in advance for your timeDon't install all of them that I can tell you. Only install the hotfixes if
you realy realy realy need them. I did install them all and it caused me
more trouble than it did good. Just wait patiently for SP4, I guess that's
much safer.
mvg
Michael
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||Hi,
If the issues in MS03-031 are applicable to you then apply MS03-031 with
826161 (this fixes a problem from MS03-031). This is the level we are aiming
at. Also SP4 should not be too long from now.
Chris Wood
Alberta Department of Energy
CANADA
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||I am new to SQL Server and have SQL Server 2000 SP3
running on Windows 2000. We are experiencing some
performance problems and I am considering applying SP3a.
I noticed in you question that you stated "I understand
that I am not supposed to install SP3a." why did you say
this, I could not find anything in the documents about
SP3a that would supoort this?
Thanks, Phil
>--Original Message--
>Don't install all of them that I can tell you. Only
install the hotfixes if
>you realy realy realy need them. I did install them all
and it caused me
>more trouble than it did good. Just wait patiently for
SP4, I guess that's
>much safer.
>mvg
>Michael
>"bonset" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0BAB4516-FE3F-4491-B619-
24EEF364BC96@.microsoft.com...
>> Hello everyone
>> I am very new at this and I really need your help.
>> We have purchased and installed an SQL Server 2000,
Product Version:
>8.00.760 (SP3) in a new Windows 2003 Server. I
understand that I am not
>supposed to install SP3a. My system is up-to-date
regarding critical updates
>from widows update service.
>> Can anyone tell me what additional hotfixes for SQL do
I have to install
>in order to keep my system healthy?
>> I am confused because I placed a query on the
Microsoft Security Bulletin
>Search Page for SQL Server 2000 (SP3) hotfixes (checked:
Show only bulletins
>that contain patches that have not been replaced by a
more recent patch.)
>and the results I got were:
>> 1. Jan 13, 2004, Buffer Overrun in MDAC Function
Could Allow Code
>Execution (832483): MS04-003, Affected Software: MDAC
2.5, MDAC 2.6, MDAC
>2.7, MDAC 2.8
>> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL
Server (815495):
>MS03-031, Affected Software: SQL Server 7.0, Microsoft
Data Engine (MSDE),
>Microsoft SQL Server 2000 Desktop Engine (MSDE 2000),
SQL Server 2000
>> The first one (832483) is installed but the second is
not. Does windows
>updates service install hotfixes for SQL Server or do I
have to install them
>manually?
>> Do I have to install this Patch 815495?
>> Do I have to install Microsoft SQL Server 2000 Desktop
Engine (MSDE 2000)
>Release A (This release includes the fixes for the
Slammer (W32.slammer)
>worm)? (I found this on another page Most Popular
Downloads)
>> Sorry for the length!
>> I thank you in advance for your time.
>
>.
>
I am very new at this and I really need your help.
We have purchased and installed an SQL Server 2000, Product Version: 8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not supposed to install SP3a. My system is up-to-date regarding critical updates from widows update service.
Can anyone tell me what additional hotfixes for SQL do I have to install in order to keep my system healthy?
I am confused because I placed a query on the Microsoft Security Bulletin Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins that contain patches that have not been replaced by a more recent patch.) and the results I got were
1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC 2.7, MDAC 2.8
2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495): MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE), Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 200
The first one (832483) is installed but the second is not. Does windows updates service install hotfixes for SQL Server or do I have to install them manually?
Do I have to install this Patch 815495?
Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A (This release includes the fixes for the Slammer (W32.slammer) worm)? (I found this on another page Most Popular Downloads
Sorry for the length
I thank you in advance for your timeDon't install all of them that I can tell you. Only install the hotfixes if
you realy realy realy need them. I did install them all and it caused me
more trouble than it did good. Just wait patiently for SP4, I guess that's
much safer.
mvg
Michael
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||Hi,
If the issues in MS03-031 are applicable to you then apply MS03-031 with
826161 (this fixes a problem from MS03-031). This is the level we are aiming
at. Also SP4 should not be too long from now.
Chris Wood
Alberta Department of Energy
CANADA
"bonset" <anonymous@.discussions.microsoft.com> wrote in message
news:0BAB4516-FE3F-4491-B619-24EEF364BC96@.microsoft.com...
> Hello everyone
> I am very new at this and I really need your help.
> We have purchased and installed an SQL Server 2000, Product Version:
8.00.760 (SP3) in a new Windows 2003 Server. I understand that I am not
supposed to install SP3a. My system is up-to-date regarding critical updates
from widows update service.
> Can anyone tell me what additional hotfixes for SQL do I have to install
in order to keep my system healthy?
> I am confused because I placed a query on the Microsoft Security Bulletin
Search Page for SQL Server 2000 (SP3) hotfixes (checked: Show only bulletins
that contain patches that have not been replaced by a more recent patch.)
and the results I got were:
> 1. Jan 13, 2004, Buffer Overrun in MDAC Function Could Allow Code
Execution (832483): MS04-003, Affected Software: MDAC 2.5, MDAC 2.6, MDAC
2.7, MDAC 2.8
> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL Server (815495):
MS03-031, Affected Software: SQL Server 7.0, Microsoft Data Engine (MSDE),
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2000
> The first one (832483) is installed but the second is not. Does windows
updates service install hotfixes for SQL Server or do I have to install them
manually?
> Do I have to install this Patch 815495?
> Do I have to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A (This release includes the fixes for the Slammer (W32.slammer)
worm)? (I found this on another page Most Popular Downloads)
> Sorry for the length!
> I thank you in advance for your time.
>|||I am new to SQL Server and have SQL Server 2000 SP3
running on Windows 2000. We are experiencing some
performance problems and I am considering applying SP3a.
I noticed in you question that you stated "I understand
that I am not supposed to install SP3a." why did you say
this, I could not find anything in the documents about
SP3a that would supoort this?
Thanks, Phil
>--Original Message--
>Don't install all of them that I can tell you. Only
install the hotfixes if
>you realy realy realy need them. I did install them all
and it caused me
>more trouble than it did good. Just wait patiently for
SP4, I guess that's
>much safer.
>mvg
>Michael
>"bonset" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0BAB4516-FE3F-4491-B619-
24EEF364BC96@.microsoft.com...
>> Hello everyone
>> I am very new at this and I really need your help.
>> We have purchased and installed an SQL Server 2000,
Product Version:
>8.00.760 (SP3) in a new Windows 2003 Server. I
understand that I am not
>supposed to install SP3a. My system is up-to-date
regarding critical updates
>from widows update service.
>> Can anyone tell me what additional hotfixes for SQL do
I have to install
>in order to keep my system healthy?
>> I am confused because I placed a query on the
Microsoft Security Bulletin
>Search Page for SQL Server 2000 (SP3) hotfixes (checked:
Show only bulletins
>that contain patches that have not been replaced by a
more recent patch.)
>and the results I got were:
>> 1. Jan 13, 2004, Buffer Overrun in MDAC Function
Could Allow Code
>Execution (832483): MS04-003, Affected Software: MDAC
2.5, MDAC 2.6, MDAC
>2.7, MDAC 2.8
>> 2. Jul 23, 2003, Cumulative Patch for Microsoft SQL
Server (815495):
>MS03-031, Affected Software: SQL Server 7.0, Microsoft
Data Engine (MSDE),
>Microsoft SQL Server 2000 Desktop Engine (MSDE 2000),
SQL Server 2000
>> The first one (832483) is installed but the second is
not. Does windows
>updates service install hotfixes for SQL Server or do I
have to install them
>manually?
>> Do I have to install this Patch 815495?
>> Do I have to install Microsoft SQL Server 2000 Desktop
Engine (MSDE 2000)
>Release A (This release includes the fixes for the
Slammer (W32.slammer)
>worm)? (I found this on another page Most Popular
Downloads)
>> Sorry for the length!
>> I thank you in advance for your time.
>
>.
>
latest enabled version of every document (was "help with sql please!")
Hi, I'm having trouble with some SQL. I have a document table which links to a document version table. I'd like to write a query to get the latest enabled version of every document - a resultset with one row per document. Is this possible with resorting to a cursor?
CREATE TABLE tblDoc (
DocId int
)
GO
CREATE TABLE tblDocVersion (
DocVersionId int,
DocId int,
DateCreated datetime,
IsEnabled bit
)
GO
INSERT INTO tblDoc (DocId) VALUES (1)
INSERT INTO tblDoc (DocId) VALUES (2)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 1, '8/8/2006' , 1)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 1, '9/9/2006' , 1)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 1, '10/10/2006' , 0)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 2, '8/8/2006' , 1)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 2, '11/11/2006' , 1)
Desired output:
DocId DocVersionId DateCreated
============================
1 2 9/9/2006
2 5 11/11/2006
Thanks!
MrsMUse a subquery:
select tblDocVersion.DocId,
tblDoVersion.DocVersionID,
tblDocVersion.DateCreated
from tblDocVersion
inner join --LastVersions
(select DocId,
max(DateCreated) as DateCreated
from tblDocVersion
group by DocId) LastVersion
on tblDocVersion.DocId = LastVersion.DocID
and tblDocVersion.DateCreated = LastVersion.DateCreated
By the way...why do you prefix your table name with "tbl"? Are you afraid you are going to forget what it is? Did your husbandBOB call and remind you to pick up some petfoodALPO for your dogFIDO today?|||ah nice, joining on a sub query - never thought of that, thanks a lot.
the tbl thing is part of the standards at my company. doesn't do anyone any harm!
thanks again|||the tbl thing is part of the standards at my company. doesn't do anyone any harm!that's highly doubtful
not the "part of the standards at my company" part
the other part
:)|||Did your husbandBOB call and remind you to pick up some petfoodALPO for your dogFIDO today?
hah! :)
i always hated hungarian. intellisense seems to be slowly killing it off in the world of compiled code thankfully. from the bible of umaintainable code (http://mindprod.com/jgloss/unmain.html):
a_crszkvc30LastNameCol:
"It took a team of maintenance engineers nearly 3 days to figure out that this whopper variable name described a const, reference, function argument that was holding information from a database column of type Varchar[30] named "LastName" which was part of the table's primary key"|||the tbl thing is part of the standards at my company. doesn't do anyone any harm!Why don't you suggest a standard that all desktop PCs be painted schoolbus yellow, all laptops be candy-striped red, and all printers have blue polka-dots? Also harmless, and just as sensible.|||I knew one team at MS that had a convention of putting _sp at the end of every sproc.
Presumably this was because they knew there was some downside to putting sp_ at the front.
I'm sure it really helped them distingush procs from tables, which, btw, all had _tbl at the end. ;)
CREATE TABLE tblDoc (
DocId int
)
GO
CREATE TABLE tblDocVersion (
DocVersionId int,
DocId int,
DateCreated datetime,
IsEnabled bit
)
GO
INSERT INTO tblDoc (DocId) VALUES (1)
INSERT INTO tblDoc (DocId) VALUES (2)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 1, '8/8/2006' , 1)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 1, '9/9/2006' , 1)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 1, '10/10/2006' , 0)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 2, '8/8/2006' , 1)
INSERT INTO tblDocVersion (DocVersionId, DocId, DateCreated, IsEnabled) VALUES (1, 2, '11/11/2006' , 1)
Desired output:
DocId DocVersionId DateCreated
============================
1 2 9/9/2006
2 5 11/11/2006
Thanks!
MrsMUse a subquery:
select tblDocVersion.DocId,
tblDoVersion.DocVersionID,
tblDocVersion.DateCreated
from tblDocVersion
inner join --LastVersions
(select DocId,
max(DateCreated) as DateCreated
from tblDocVersion
group by DocId) LastVersion
on tblDocVersion.DocId = LastVersion.DocID
and tblDocVersion.DateCreated = LastVersion.DateCreated
By the way...why do you prefix your table name with "tbl"? Are you afraid you are going to forget what it is? Did your husbandBOB call and remind you to pick up some petfoodALPO for your dogFIDO today?|||ah nice, joining on a sub query - never thought of that, thanks a lot.
the tbl thing is part of the standards at my company. doesn't do anyone any harm!
thanks again|||the tbl thing is part of the standards at my company. doesn't do anyone any harm!that's highly doubtful
not the "part of the standards at my company" part
the other part
:)|||Did your husbandBOB call and remind you to pick up some petfoodALPO for your dogFIDO today?
hah! :)
i always hated hungarian. intellisense seems to be slowly killing it off in the world of compiled code thankfully. from the bible of umaintainable code (http://mindprod.com/jgloss/unmain.html):
a_crszkvc30LastNameCol:
"It took a team of maintenance engineers nearly 3 days to figure out that this whopper variable name described a const, reference, function argument that was holding information from a database column of type Varchar[30] named "LastName" which was part of the table's primary key"|||the tbl thing is part of the standards at my company. doesn't do anyone any harm!Why don't you suggest a standard that all desktop PCs be painted schoolbus yellow, all laptops be candy-striped red, and all printers have blue polka-dots? Also harmless, and just as sensible.|||I knew one team at MS that had a convention of putting _sp at the end of every sproc.
Presumably this was because they knew there was some downside to putting sp_ at the front.
I'm sure it really helped them distingush procs from tables, which, btw, all had _tbl at the end. ;)
Latest build version?
Hi,
What is the latest patch level for SQL server 2000?
I am currently at this build level:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
How can I tell when microsoft bring out a new SQL server hotfix or patch?Check out http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37. I think that they keep the list updated, but I could not tell you how frequently.
Note that with some of the patches that come out, you have to patch the client tools as well as the server.
Regards,
hmscott
Hi,
What is the latest patch level for SQL server 2000?
I am currently at this build level:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
How can I tell when microsoft bring out a new SQL server hotfix or patch?
What is the latest patch level for SQL server 2000?
I am currently at this build level:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
How can I tell when microsoft bring out a new SQL server hotfix or patch?Check out http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37. I think that they keep the list updated, but I could not tell you how frequently.
Note that with some of the patches that come out, you have to patch the client tools as well as the server.
Regards,
hmscott
Hi,
What is the latest patch level for SQL server 2000?
I am currently at this build level:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
How can I tell when microsoft bring out a new SQL server hotfix or patch?
Wednesday, March 21, 2012
Last release of Microsoft SQL Server Express Edition with Advanced Services Service pack 2
Hi all;
I have a SQL Server Express Edition with Advanced Services with Service pack
2, but I want to get sure that I have the last version of service pack 2
which released by Microsoft (released by Microsoft) and not a CTP
The version that installed at my computer has a number: 9.00.3033.00
Do Microsoft released Service pack 2 or has just released Service pack 1
till now.
Any help and support will be appreciated
The last version of SP2 hasn't been released yet so I doubt that you have
it.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:uhmp7rhPHHA.3544@.TK2MSFTNGP03.phx.gbl...
> Hi all;
>
> I have a SQL Server Express Edition with Advanced Services with Service
> pack 2, but I want to get sure that I have the last version of service
> pack 2 which released by Microsoft (released by Microsoft) and not a CTP
>
> The version that installed at my computer has a number: 9.00.3033.00
> Do Microsoft released Service pack 2 or has just released Service pack 1
> till now.
>
> Any help and support will be appreciated
>
>
>
I have a SQL Server Express Edition with Advanced Services with Service pack
2, but I want to get sure that I have the last version of service pack 2
which released by Microsoft (released by Microsoft) and not a CTP
The version that installed at my computer has a number: 9.00.3033.00
Do Microsoft released Service pack 2 or has just released Service pack 1
till now.
Any help and support will be appreciated
The last version of SP2 hasn't been released yet so I doubt that you have
it.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:uhmp7rhPHHA.3544@.TK2MSFTNGP03.phx.gbl...
> Hi all;
>
> I have a SQL Server Express Edition with Advanced Services with Service
> pack 2, but I want to get sure that I have the last version of service
> pack 2 which released by Microsoft (released by Microsoft) and not a CTP
>
> The version that installed at my computer has a number: 9.00.3033.00
> Do Microsoft released Service pack 2 or has just released Service pack 1
> till now.
>
> Any help and support will be appreciated
>
>
>
Last release of Microsoft SQL Server Express Edition with Advanced Services Service pack 2
Hi all;
I have a SQL Server Express Edition with Advanced Services with Service pack
2, but I want to get sure that I have the last version of service pack 2
which released by Microsoft (released by Microsoft) and not a CTP
The version that installed at my computer has a number: 9.00.3033.00
Do Microsoft released Service pack 2 or has just released Service pack 1
till now.
Any help and support will be appreciated> The version that installed at my computer has a number: 9.00.3033.00
> Do Microsoft released Service pack 2 or has just released Service pack 1
> till now.
Microsoft SQL Server 2005, 2000 and 7.0 Builds
http://sqlserverbuilds.blogspot.com/|||The last version of SP2 hasn't been released yet so I doubt that you have
it.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:uhmp7rhPHHA.3544@.TK2MSFTNGP03.phx.gbl...
> Hi all;
>
> I have a SQL Server Express Edition with Advanced Services with Service
> pack 2, but I want to get sure that I have the last version of service
> pack 2 which released by Microsoft (released by Microsoft) and not a CTP
>
> The version that installed at my computer has a number: 9.00.3033.00
> Do Microsoft released Service pack 2 or has just released Service pack 1
> till now.
>
> Any help and support will be appreciated
>
>
>sql
I have a SQL Server Express Edition with Advanced Services with Service pack
2, but I want to get sure that I have the last version of service pack 2
which released by Microsoft (released by Microsoft) and not a CTP
The version that installed at my computer has a number: 9.00.3033.00
Do Microsoft released Service pack 2 or has just released Service pack 1
till now.
Any help and support will be appreciated> The version that installed at my computer has a number: 9.00.3033.00
> Do Microsoft released Service pack 2 or has just released Service pack 1
> till now.
Microsoft SQL Server 2005, 2000 and 7.0 Builds
http://sqlserverbuilds.blogspot.com/|||The last version of SP2 hasn't been released yet so I doubt that you have
it.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:uhmp7rhPHHA.3544@.TK2MSFTNGP03.phx.gbl...
> Hi all;
>
> I have a SQL Server Express Edition with Advanced Services with Service
> pack 2, but I want to get sure that I have the last version of service
> pack 2 which released by Microsoft (released by Microsoft) and not a CTP
>
> The version that installed at my computer has a number: 9.00.3033.00
> Do Microsoft released Service pack 2 or has just released Service pack 1
> till now.
>
> Any help and support will be appreciated
>
>
>sql
Monday, March 19, 2012
Last Modified Date of the Database Object ?
Dear All,
In order to get a version control.
I would like to get the last modified date of the Store Procedure, Table De
finition
I find the the [sysobjects] Table ONLY contains a Create Date.
How can i find it.
Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
Thank you very much
EricLunCurrent versions of SQL Server do not track modifications to objects, only
creation. You will have to track these yourself, or use a third party
product to do so. Your version control strategy, by the way, should not
rely on a feature of the product. In other words, if you were using version
control tools, you should have alter scripts stored in your source control
tool, without having to look at the database (other than to verify that what
is deployed exists in source control, or vice versa).
http://www.aspfaq.com/2495
Yukon will offer DDL triggers, but that's several months away, at least.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"EricLun >" <eric_klyuen@.yahoo.com.hk <no spam pls> wrote in message
news:DCE9AA09-6AF7-4BFD-A576-6D730BD4D79B@.microsoft.com...
Definition
In order to get a version control.
I would like to get the last modified date of the Store Procedure, Table De
finition
I find the the [sysobjects] Table ONLY contains a Create Date.
How can i find it.
Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
Thank you very much
EricLunCurrent versions of SQL Server do not track modifications to objects, only
creation. You will have to track these yourself, or use a third party
product to do so. Your version control strategy, by the way, should not
rely on a feature of the product. In other words, if you were using version
control tools, you should have alter scripts stored in your source control
tool, without having to look at the database (other than to verify that what
is deployed exists in source control, or vice versa).
http://www.aspfaq.com/2495
Yukon will offer DDL triggers, but that's several months away, at least.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"EricLun >" <eric_klyuen@.yahoo.com.hk <no spam pls> wrote in message
news:DCE9AA09-6AF7-4BFD-A576-6D730BD4D79B@.microsoft.com...
quote:
> Dear All,
> In order to get a version control.
> I would like to get the last modified date of the Store Procedure, Table
Definition
quote:|||Thank you very much form your help.
> I find the the [sysobjects] Table ONLY contains a Create Date.
> How can i find it.
> Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
> Thank you very much
> EricLun
Last Modified Date of the Database Object ?
Dear All,
In order to get a version control.
I would like to get the last modified date of the Store Procedure, Table Definition
I find the the [sysobjects] Table ONLY contains a Create Date.
How can i find it.
Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
Thank you very much
EricLunCurrent versions of SQL Server do not track modifications to objects, only
creation. You will have to track these yourself, or use a third party
product to do so. Your version control strategy, by the way, should not
rely on a feature of the product. In other words, if you were using version
control tools, you should have alter scripts stored in your source control
tool, without having to look at the database (other than to verify that what
is deployed exists in source control, or vice versa).
http://www.aspfaq.com/2495
Yukon will offer DDL triggers, but that's several months away, at least.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"EricLun >" <eric_klyuen@.yahoo.com.hk <no spam pls> wrote in message
news:DCE9AA09-6AF7-4BFD-A576-6D730BD4D79B@.microsoft.com...
> Dear All,
> In order to get a version control.
> I would like to get the last modified date of the Store Procedure, Table
Definition
> I find the the [sysobjects] Table ONLY contains a Create Date.
> How can i find it.
> Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
> Thank you very much
> EricLun|||Thank you very much form your help.
In order to get a version control.
I would like to get the last modified date of the Store Procedure, Table Definition
I find the the [sysobjects] Table ONLY contains a Create Date.
How can i find it.
Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
Thank you very much
EricLunCurrent versions of SQL Server do not track modifications to objects, only
creation. You will have to track these yourself, or use a third party
product to do so. Your version control strategy, by the way, should not
rely on a feature of the product. In other words, if you were using version
control tools, you should have alter scripts stored in your source control
tool, without having to look at the database (other than to verify that what
is deployed exists in source control, or vice versa).
http://www.aspfaq.com/2495
Yukon will offer DDL triggers, but that's several months away, at least.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"EricLun >" <eric_klyuen@.yahoo.com.hk <no spam pls> wrote in message
news:DCE9AA09-6AF7-4BFD-A576-6D730BD4D79B@.microsoft.com...
> Dear All,
> In order to get a version control.
> I would like to get the last modified date of the Store Procedure, Table
Definition
> I find the the [sysobjects] Table ONLY contains a Create Date.
> How can i find it.
> Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
> Thank you very much
> EricLun|||Thank you very much form your help.
Subscribe to:
Posts (Atom)