8 replies
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
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.
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 frank-mw
by eansor
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending