how to determine if sql server sp4 has been installed?

Hello,
We are doing some maintenance on a small business sever and need to know how
to determine if sp4 for sql server 2k has been installed.
Is there a way to make this determination using tsql?
Thanks,
RichOn Wed, 15 Feb 2006 17:28:16 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:

>Hello,
>We are doing some maintenance on a small business sever and need to know ho
w
>to determine if sp4 for sql server 2k has been installed.
>Is there a way to make this determination using tsql?
>Thanks,
>Rich
SELECT @.@.version
then compare results to:
http://support.microsoft.com/defaul...b;en-us;q321185
Roy|||SELECT SERVERPROPERTY('ProductLevel') will return 'SP4' if installed. Also
SELECT @.@.VERSION will include '8.00.2039' (or higher build with hotfixes).
Hope this helps.
Dan Guzman
SQL Server MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:A30FCB02-59CF-4098-AB0C-FDB9429D7241@.microsoft.com...
> Hello,
> We are doing some maintenance on a small business sever and need to know
> how
> to determine if sp4 for sql server 2k has been installed.
> Is there a way to make this determination using tsql?
> Thanks,
> Rich|||SELECT @.@.VERSION
SP4 = 8.00.2039
(but you should have the hotfix 2040 at least)
Some links:
http://www.aspfaq.com/2160
http://www.aspfaq.com/2543
http://www.aspfaq.com/sql2000builds.asp
http://support.microsoft.com/kb/899761
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:A30FCB02-59CF-4098-AB0C-FDB9429D7241@.microsoft.com...
> Hello,
> We are doing some maintenance on a small business sever and need to know
> how
> to determine if sp4 for sql server 2k has been installed.
> Is there a way to make this determination using tsql?
> Thanks,
> Rich|||Thanks all for your replies. THat gave us the information we needed.
"Rich" wrote:

> Hello,
> We are doing some maintenance on a small business sever and need to know h
ow
> to determine if sp4 for sql server 2k has been installed.
> Is there a way to make this determination using tsql?
> Thanks,
> Rich