How To Determine Which SQL Server Service Pack Is Installed? 2

[osjohnm]

Hi

Where(if possible) would I be able to find out which version of SQL Server 2000 Service Pack is installed?
I know that Windows 2000 Service Pack can be found under Add/Remove Programs and almost everywhere else where there is any system info. Sql Server doesn't seem to do that.

If anyone knows I would really appreciate it.

Thanks

John

 

[RobertT687]

From Microsoft Knowledgebase:
To determine which Service Pack level your SQL Server server is currently running, run the following statement from the SQL Server Query Analyzer window:

SELECT @@version
The result of this query is:
8.00.194 if SQL Server 2000 with no service pack applied
8.00.384 if SQL Server 2000 Service Pack 1
8.00.534 if SQL Server 2000 Service Pack 2

 

[reden55]

go to query analyzer and type in
"select @@version"

hit f5 to run

compare output to following list
SQL Server Versions
@@Version
SQL Server Version
Released

6.50.201
SQL Server 6.5 RTM


6.50.213
SQL Server 6.5 with Service Pack 1


6.50.240
SQL Server 6.5 with Service Pack 2


6.50.258
SQL Server 6.5 with Service Pack 3


6.50.281
SQL Server 6.5 with Service Pack 4


6.50.415
SQL Server 6.5 with Service Pack 5


6.50.416
SQL Server 6.5 with Service Pack 5a


7.00.623
SQL Server 7.0 / MSDE 1.0 RTM


7.00.699
SQL Server 7.0 SP1
July 1999

7.00.842
SQL Server 7.0 SP2
March 20th, 2000

7.00.961
SQL Server 7.0 SP3
December 15th, 2000

8.00.194
SQL Server 2000 RTM


8.00.384
SQL Server 2000 SP1


8.00.534
SQL Server 2000 SP2
November 30th, 2001

 

[osjohnm]

Thanks