Another example of MS making it hard to quickly check what version of a software you are running.

Use the SQL script below to find your SMS sites service pack version level for SMS 2.0 or SMS 2003 sites.

SQL Query:

Select
SiteCode,
SiteServer,
SiteName,

'Version' = Case
When Version between '2.00.1239.0000' And '2.00.1239.0999'
Then 'SMS Version 2.0 RTM'
When Version between '2.00.1380.1000' And '2.00.1380.1999'
Then 'SMS Version 2.0 Service Pack 1'
When Version between '2.00.1493.2000' And '2.00.1493.2999'
Then 'SMS Version 2.0 Service Pack 2'
When Version between '2.00.1493.3000' And '2.00.1493.3999'
Then 'SMS Version 2.0 Service Pack 3'
When Version between '2.00.1493.4000' And '2.00.1493.4999'
Then 'SMS Version 2.0 Service Pack 4'
When Version between '2.00.1493.5000' And '2.00.1493.5999'
Then 'SMS Version 2.0 Service Pack 5'
When Version = '2.50.2726.0018'
Then 'SMS 2003 RTM'
When Version = '2.50.3174.1018'
Then 'SMS 2003 SP 1'
When Version = '2.50.4160.2000'
Then 'SMS 2003 SP 2'
Else 'Unable To Determine Service Pack!'
End

From Sites