Re: SQL thinks it's Slammer



No it cannot.

Slammer exploits a known issue in the product and the fix address the issue
so that the exploit no longer works. Also, the fix was available long before
SP4 and was subsequently rolled into SP3/3a.

Many SQL Server installations handle thousands of users concurrently. It
there were a mechanism that shuts SQL Server down because it detects lots of
queries coming in, thousands of customers would've come to a grinding halt.

Are you having some specific problems with your SQL Server? If so, posting
the details of your problems would be easier for folks here to provide
assistance.



joe.


"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C2190C0-AA5A-4312-A3CC-85B70ED454E0@xxxxxxxxxxxxxxxx
Can SQL server 2000 think that the slammer virus is affecting it and start
shutting it's services down, or limiting it's service? I was told that sql
2000 SP4 has the slammer fix, and if multiple queries are used the SQL
server
thinks it's the slammer virus. Is this true? Is there a way to prevent
this
if so?


.



Relevant Pages

  • Re: MicroMonopoly aids Terrorism?
    ... >> Not if the patch makes it so you can't use SQL server. ... >> the multitudes of MS patches that get released. ... > No one is disputing that MS was hit by Slammer. ...
    (microsoft.public.security)
  • Re: Hotfix Post SP4
    ... Build 2148, to fix the SQLDiag issue, but also fixes another 10 or so. ... to fix the Query Analyzer DTC issue. ... SQL Server Version Database ... You receive an error message if you use the sp_addalias or sp_dropalias ...
    (microsoft.public.sqlserver.clustering)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... Earl Newcomer wrote: ... >fix of 1*value and it works as you mentioned. ... As far as I can tell, so long as SQL Server has to do an arithmetic ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)
  • Re: Win32/SQLSlammer.virus
    ... Just a quick one regarding the Slammer; is MS SQL Server 7 ... >process which is using 90% or more CPU? ... >consuming huge amounts of memory. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2000 SP4 - realease date
    ... it looks like SP4 is targeted for the first half ... there is no "fix" with UMS non-yielding processes ... New concurrency and scheduling diagnostics added to SQL Server: ... FIX: You are prompted for password confirmation after you change a standard ...
    (microsoft.public.sqlserver.server)