MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
FAQ  
Administration  
Backup/Restore  
Connectivity  
Development  
General  
Installation  
OLAP  
Replication  
Transfer/move  
Trouble  
SQL 6.5  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 


How can I check what SQL service pack am I running?

Answer:

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

7.00.623  - SQL Server 7.0 release
7.00.699  - SQL Server 7.0 SP1
7.00.842  - SQL Server 7.0 SP2
7.00.961  - SQL Server 7.0 SP3
7.00.1063 - SQL Server 7.0 SP4

6.50.201 - SQL Server 6.5 release.
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
See also this link to download the SQL Server service packs:
Where can I download the SQL Server service packs?


 

 
Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2010 Bits on the Wire, Inc