Wednesday, March 28, 2012

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?Have you applied SQL SP3? This almost sounds like a SQL Slammer problem.|||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?|||select serverproperty('ProductLevel')

You can download sp3 for sqlserver from Microsoft website.|||You should go for SP3 right now, and as prescribed download the pack from MS SQL (http://www.microsoft.com/sql) website to get rid of the issues and also refer to SLAMMER affected measures in the website.|||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/downloads/2000/sp3.asp?&SD=GN&LN=EN-US&gssnb=1

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

http://support.microsoft.com/?kbid=814410|||here is the complete link. don't know what happened last post.

http://www.microsoft.com/sql/downloads/2000/sp3.asp?&SD=GN&LN=EN-US&gssnb=1

No comments:

Post a Comment