Latest SP & patches for SQLserver 2000


    Sponsored Links


  • 1. Urgent Error
    Hi all, I had server crash down. Now from a .bak I am have restored the database, but when i am trying to make any changes into a table of the database it gives me this error can any one help me in this. Error Description: Another user has modified the contents of this table or view; the database row you are modifying no longer exists in database Thanks in advance Regards Dhaval
  • 2. sql server 7.0 enterprise wont install on windows 2000
    ...and for the record this behaviour has been altered in SQL2K ent (i.e installs on either std or adv but will inherit any of the restrictions imposed by that OS e.g. no AWE on 2k std) -- BR, Mark Broadbent mcse+i, mcdba _________________________ "Keith Kratochvil" < XXXX@XXXXX.COM > wrote in message news:% XXXX@XXXXX.COM ... You can install SQL 7 Standard Edition....but you have the ENTERPRISE Edition. This edition is only supported on Win2k Advanced Server. -- Keith, SQL Server MVP "rich" < XXXX@XXXXX.COM > wrote in message news:02f201c35087$0e69d610$ XXXX@XXXXX.COM ... > I attempted to install sql server 7.0 enterprise on a > server loaded with Windows 2000 server. I get a setup > error: The Enterprise Edition server component cannot be > installed on Windows NT Server using this CD. Only client > components will be installed. > > Can't I install sql server 7.0 on windows 2000? > > Help! > > Thanks Rich
  • 3. Problem installing SQL2k over SQL7 MSDE....Q300676
    Hello, To resolve a problem i am having with installing SQL2000 the MS support site says to download the following file.... When i try to download the file it fails. Could someone please email me this file please.... XXXX@XXXXX.COM Thanks Matthew
  • 4. How to Install Localized SQL Server Error Messages
    I am trying to localize SQL Server errors into spanish and found "Microsoft Knowledge Base Article - 277535" "How to Install Localized SQL Server Error Messages". It mentions a file "s80xlang.exe" that I have not been able to find anywhere. Any ideas where I can download this file? Thanks in advance,

Latest SP & patches for SQLserver 2000

Postby Bill Nguyen » Sat, 15 Nov 2003 07:05:22 GMT

I can't find the place in SQLserver Enterprise manager to get the display of
it's version. Most of other software would show it in Help | About.
Also, can you please tell me the latest SP & patches for SQLserver 2K? My
server suddendly getting very slow.

Re: Latest SP & patches for SQLserver 2000

Postby Tibor Karaszi » Sat, 15 Nov 2003 07:24:08 GMT

I assume that you want the sp version for the server and not for EM.
Right-click the server, properties.

Tibor Karaszi, SQL Server MVP
Archive at:


Re: Latest SP & patches for SQLserver 2000

Postby Bill Nguyen » Sat, 15 Nov 2003 09:56:16 GMT

Thanks Tibor.

"Tibor Karaszi" < XXXX@XXXXX.COM >



Re: Latest SP & patches for SQLserver 2000

Postby kris yumul [MS] » Sat, 15 Nov 2003 11:15:50 GMT

To determine which version of SQL Server 2000 is running, connect to SQL
Server 2000 by using Query Analyzer, and then run the following code:
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),

The results are:

          The product version (for example, 8.00.534).

          The product level (for example, "RTM" or "SP2").

          The edition (for example, "Desktop Engine").

Kris Yumul [MS]

This posting is provided "AS IS" with no warranties, and confers no rights



Similar Threads:

1.SSRS 2000 printing after latest SP applied

Good day,

I have applied th latest SP for SSRS 2000, I think it is 2. I can print and 
do all the fantastic new things with the SP, thanks MS, the printing is a 
major help.

I have a problem with a machine that is running Windows 95, I can't print 
from it. I shows the print icon but when one presses it nothing happens, I 
get a explorer error:
Object doesn't support this property or method.

Can anyone help. Is it because it is 95, possibly the IE version.

Please some one help me.


2.SQL 2000 Query slowed many times after SP 4 patch

3.Big problem with sqlserver 2000 msde sp 4 ...

4.Caution with latest SQL Security Patch

The Cumulative Patch for Microsoft SQL Server (815495) issued on July 
23 caused severe problems with my MS Small Business Server 4.5 system, 
specifically disabling Remote Access Connection Manager, Remote Access 
Server, Internet Information Service, and the SBS Console.
Uninstall is not available for the patch. Working with MS Tech 
Support, attempts at replacing msvcrt.dll and rpc4.dll in System 32 
with previous versions of those files failed. Either that or the next 
step, re-applying Windows NTService Pack 6a, caused my SBS to be 
completely unbootable. Ultimately, hours later, the only solution was 
to restore the server to its pre-SQL-patch state from backup tapes.

Subsequently MS Tech Support called and confirm that they were able to 
duplicate the problem internally.

5.Receiving DTC error after Windows Patch for latest zotob

Receiving "Failed to obtain TransactionDispenserInterface: Result Code = 
0x8004d01b"  in the error log of the SQL Server after the Windows Admins have 
patched the server.  The MSDTC service is running and I don't see anything in 
the Event Logs of the server.

Any clues on how to troubleshoot this?

6. latest patch

7. Applying the latest 2K5 CU Patch -- Scare me out of it

8. plperlng - plperlng: update for latest patch from CP



Who is online

Users browsing this forum: No registered users and 51 guest