Checking version info for Service Packs

Checking version info for Service Packs

Post by Dinesh T » Wed, 02 Jan 2002 01:21:45



Rick,

842 is SP2.

Run this in Query Analyzer as a nice friendly output:

SET NOCOUNT ON




-- 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 '584' THEN 'SP2'

END AS 'SERVICE PACK'
set nocount off

Dinesh.


> How can I check the version information concerning service

> query analyzer, (returns version number 7.00.842).
> However there is'nt any mention of service pack version.

 
 
 

Checking version info for Service Packs

Post by Rick Brightwel » Wed, 02 Jan 2002 01:33:59


Thanks!  It worked beautifully.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!