Discussion Locked

How to check what SP has been applied

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How to check what SP's have been applied for W2000 and SQL2000 ?

8 replies

by don christner

Many times you can launch the application, click on Help and then About and it will show you the version and service pack.

Another way is to go to windowsupdate.com then click on View Update History (in the left hand frame). This will show you all updates that have been applied to your computer and when they were installed.

Don

by stgcit

check in to system control panel. to see the sp installed for W2000. for sql i think u can check the properties in the mmc console.

by nccorthu

Easier
Just take any windows program Including Win2k go to the Help ABOUT XXXX( Prog name) Itwill tell you.
In win 2k Operating systems its in Windows Explorer

In Win SQL its at the same place. That's a "rule" in Windows.

by sgt_shultz

for windows, it's ver or winver
for windows 2000, Start/Run/winver
for SQL, go to Help/About MS SQL Server...?

by thechas

For personal use, Belarc Advisor provides a full list of installed service packs and patches.

www.belarc.com

It even lists installed patches that are not properly operating.

Chas

by frank-mw

This is for SQL 2K
****************************
To check current SQL Server service pack, you can use this query:

select @@version

The following versions are available:

8.00.194 - SQL Server 2000 release
8.00.384 - SQL Server 2000 SP1
8.00.534 - SQL Server 2000 SP2
8.00.760 - SQL Server 2000 SP3

To check for W2K
USE the SPcheck tool (!)
READ:
Microsoft Knowledge Base Article - Q279631
http://support.microsoft.com/default.aspx?scid=kb;en-us;279631

by eansor

For Windows 2000 all you have to do is right click on the My Computer icon on your desktop. This will bring up a drop down menu. Select the Properties line item. This will bring up the System Properties window. There you can see many properties associated with your system, including which Service Pack has been installed. I don't run SQL 2000 so I can't answer that part of your question, but I'm sure that either About SQL under help or some query will provide what you are looking for. Someone else might offer a solution to that part of your question. Hope this helps.

This discussion is closed to new replies.