Re: identify sp
From: Drew (cladre_at_hotmail.com)
Date: 10/30/03
- Next message: John Gorman: "Windows authentication"
- Previous message: Adam Machanic: "Re: Is encryption of SQL Server necessary or even recommended"
- In reply to: Uri Dimant: "Re: identify sp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: 30 Oct 2003 06:43:38 -0800
Someone sent me this recently... probably from a posting on Google.
Run this in Query Analyzer.
SET NOCOUNT ON
SELECT CONVERT(CHAR(25),@@SERVERNAME) AS 'SQL SERVER',
SUBSTRING(@@VERSION,23,4) AS 'PRODUCT VERSION',
SUBSTRING(@@VERSION,35,3) AS 'BUILD NUMBER',
CASE SUBSTRING(@@VERSION,35, 3)
-- 6.5
WHEN '121' THEN 'NO SP'
WHEN '124' THEN 'SP1'
WHEN '139' THEN 'SP2'
WHEN '151' THEN 'SP3'
WHEN '201' THEN 'NO SP'
WHEN '213' THEN 'SP1'
WHEN '240' THEN 'SP2'
WHEN '252' THEN 'SP3 ** BAD **'
WHEN '258' THEN 'SP3'
WHEN '259' THEN 'SP3 + SBS'
WHEN '281' THEN 'SP4'
WHEN '297' THEN 'SP4 + SBS'
WHEN '339' THEN 'SP4 + Y2K'
WHEN '415' THEN 'SP5 ** BAD **'
WHEN '416' THEN 'SP5a'
-- 7.0
WHEN '198' THEN 'Beta 1'
WHEN '517' THEN 'Beta 3'
WHEN '583' THEN 'RC1'
WHEN '623' THEN 'NO SP'
WHEN '689' THEN 'SP1 Beta'
WHEN '699' THEN 'SP1'
WHEN '835' THEN 'SP2 Beta'
WHEN '842' THEN 'SP2'
WHEN '961' THEN 'SP3'
-- 2000
WHEN '194' THEN 'NO SP'
WHEN '384' THEN 'SP1'
WHEN '534' THEN 'SP2'
ELSE 'Unknown - may be a Hot-Fix version or script out of date'
END AS 'SERVICE PACK'
set nocount off
Drew.
"Uri Dimant" <urid@iscar.co.il> wrote in message news:<evoshmrnDHA.2820@TK2MSFTNGP10.phx.gbl>...
> Supernova
> 7.50.198 SQL Server 7.5/2000 Beta 1
> 7.00.517 SQL Server 7.0 Beta 3
> 7.00.583 SQL Server 7.0 RC1
> 7.00.623 SQL Server 7.0 "gold" release
> 7.00.677 MSDE from Office 2000
> 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.0.1073 SQL 7 OLAP "gold" release
> 7.0.1245 SQL 7 OLAP SP1
> 7.0.1325 SQL 7 OLAP SP2 Beta
> 7.0.1458 SQL 7 OLAP SP2
>
>
>
> 7.00.623 for SQL Server 7.0 with no service pack applied
> 7.00.699 for SQL Server 7.0 Service Pack 1,
> 7.00.842 for SQL Server 7.0 Service Pack 2
> 7.00.961 for SQL Server 7.0 Service Pack 3
>
>
>
>
> "supernova" <abc@yahoo.com> wrote in message
> news:espX8ZrnDHA.1728@TK2MSFTNGP09.phx.gbl...
> > How do you identify the service pack on SQL 7.0? I ran "select @@version"
> > and it gives:
> >
> > 7.00.1094 in one SQL 7
> > 7.00.961 in another SQL 7
> >
> > do these tell anything?
> >
> > Thanks.
> >
> >
- Next message: John Gorman: "Windows authentication"
- Previous message: Adam Machanic: "Re: Is encryption of SQL Server necessary or even recommended"
- In reply to: Uri Dimant: "Re: identify sp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
