How to tell if SQL SP4 is installed

I have a SQL Server running and I need to know if SP4 is installed on it.
How can I tell?
Thanks,
Chrishttp://support.microsoft.com/kb/q321185/
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>|||Enterprise manage, right click on the server in question under the server
group, select properties and you should see product with SP version
"Chris Hedlund" wrote:

> I have a SQL Server running and I need to know if SP4 is installed on it.
> How can I tell?
> Thanks,
> Chris
>
>|||It's one thing to find the version number, but another to match it up with
the actual service pack/patch level. You can paste the below into your
Query Analyzer and run it - it should tab out correctly. If not, use this
as a reference: http://vyaskn.tripod.com/sqlsps.htm
SET NOCOUNT ON
print 'C.1 Current SQL Server Version'
print 'DM1769: CAT I'
print 'The IAO will ensure that the SQL Server version has all patches and
hotfixes applied.'
print ''
print 'SQL Server Version Table:'
print char(9) + char(9) + char(9) + 'No SP SP1 SP2 SP3 / SP3a SP4
SP5 SP5a'
print 'SQL Server 6.0' + char(9) + char(9) + '6.00.121 6.00.124' + char(9)
+ '6.00.139' + char(9) + '6.00.151'
print 'SQL Server 6.5' + char(9) + char(9) + '6.50.201' + char(9) +
'6.50.213' + char(9) + '6.50.240' + char(9) + '6.50.258' + char(9) +
'6.50.281' + char(9) + '6.50.415' + char(9) + '6.50.416'
print 'SQL Server 7.0' + char(9) + char(9) + '7.00.623' + char(9) +
'7.00.699' + char(9) + '7.00.842' + char(9) + '7.00.961' + char(9) +
'7.00.1063'
print 'SQL Server 2000' + char(9) + char(9) + '8.00.194' + char(9) +
'8.00.384' + char(9) + '8.00.534' + char(9) + '8.00.760' + char(9) +
'8.00.2039'
print 'SQL Server 2005' + char(9) + char(9) + '9.00.1399.06 '
print
'=======================================
====================================
========================================
====='
declare @.result varchar(255)
exec xp_msver 'ProductVersion'
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>