query to run to find SQL SP upgrade successful

I want to run a query in QA om each server to ensure that I have upgraded
all my SQL Servers to SP3a along with the MS03-031 SQL security patch
ThanksHassan wrote:
> I want to run a query in QA om each server to ensure that I have
> upgraded all my SQL Servers to SP3a along with the MS03-031 SQL
> security patch
> Thanks
From T-SQL just execute @.@.version (SP3 is version 760). Since that
hotfix does not modify the SQL Server version (as it can be applied to
both SQL 7 and 2000), you need to follow this article to see if the
patch is applied:
http://support.microsoft.com/?kbid=815495
--
David Gugick
Imceda Software
www.imceda.com|||On Sat, 9 Apr 2005 20:57:37 -0700, "Hassan" <fatima_ja@.hotmail.com>
wrote:
>I want to run a query in QA om each server to ensure that I have upgraded
>all my SQL Servers to SP3a along with the MS03-031 SQL security patch
>Thanks
SELECT ServerProperty('ProductLevel')
will give you a very succinct answer as to which service pack has been
applied.
Andrew Watt
MVP - InfoPath|||Hi
MS03-031 is build 818.
SELECT SERVERPROPERTY('ProductVersion') will return for the minor version,
760 for SP3 and 818 for MS03-31
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:e23LCVZPFHA.3076@.tk2msftngp13.phx.gbl...
> Hassan wrote:
>> I want to run a query in QA om each server to ensure that I have
>> upgraded all my SQL Servers to SP3a along with the MS03-031 SQL
>> security patch
>> Thanks
> From T-SQL just execute @.@.version (SP3 is version 760). Since that hotfix
> does not modify the SQL Server version (as it can be applied to both SQL 7
> and 2000), you need to follow this article to see if the patch is applied:
> http://support.microsoft.com/?kbid=815495
> --
> David Gugick
> Imceda Software
> www.imceda.com