|
|
|
|
Sometimes you need to find out which service pack version you are running on SQL Server. First, run this command in ISQL/W or Query Analyzer:
SELECT @@Version
Once you have the version number, then match it to the list below to find which SQL Server service pack you are using.
2000.8.00.760 SQL Server 2000 SP3
2000.8.00.534 SQL Server 2000 SP2
2000.8.00.384 SQL Server 2000 SP1
2000.8.00.194.0 SQL Server 2000 "gold" release, no SP
7.00.623 SQL Server 7.0 "gold" release, no SP
7.00.677 MSDE in Office 2000, Office Developer
7.00.689 SQL Server 7.0 SP1 Beta
7.00.699 SQL Server 7.0 SP1
7.00.835 SQL Server 7.0 SP2 Beta
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 "gold" release
6.50.213 SQL Server 6.5 with SP1
6.50.240 SQL Server 6.5 with SP2
6.50.252 SQL Server 6.5 with "bad" SP3. Do not use.
6.50.258 SQL Server 6.5 with SP3
6.50.259 SQL Server 6.5 on SBS only
6.50.281 SQL Server 6.5 with SP4
6.50.297 SQL Server 6.5 included in Site Server 3
6.50.339 SQL Server 6.5 "Y2K" Hot-fix
6.50.415 SQL Server 6.5 with "bad" SP5. Do not use.
6.50.416 SQL Server 6.5 with SP5a
6.50.479 SQL Server 6.5 with "post SP5a update" |
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|