Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2002
    Posts
    9

    Unanswered: Microsoft SQL 2000 Troubling the Network

    We have installed Microsoft SQL 2000 on a Windows NT Server, which is connected to our network, that have one more Novell Network Server.

    When we start the MSSQL2000 database, after a while the network is jammed, and everyone is facing difficulties to work in the network. When we stop this SQL server the network speed comes to normal.

    Please guide me to fix this problem?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Have you applied SQL SP3? This almost sounds like a SQL Slammer problem.

  3. #3
    Join Date
    Mar 2002
    Posts
    9
    Thanks for your reply, I don't think that we did that. Please tell me how to check whether sp3 is there? if not where to get it?

  4. #4
    Join Date
    Apr 2003
    Posts
    30
    select serverproperty('ProductLevel')

    You can download sp3 for sqlserver from Microsoft website.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You should go for SP3 right now, and as prescribed download the pack from MS SQL website to get rid of the issues and also refer to SLAMMER affected measures in the website.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    May 2003
    Posts
    23
    A note about SP3.

    We applied SP3 to a database which was a replication publisher, and it could no longer produce snapshots.

    There is a Service Pack 3a -- I recommend it over SP3. SP3 can cause problems, including start-up and MDAC problems.

    See:
    http://www.microsoft.com/sql/downloa...=EN-US&gssnb=1

    http://support.microsoft.com/?kbid=814572

    http://support.microsoft.com/?kbid=814410

  7. #7
    Join Date
    May 2003
    Posts
    23
    here is the complete link. don't know what happened last post.

    http://www.microsoft.com/sql/downloa...=EN-US&gssnb=1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •