Run the following query.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

-----Original Message-----
From: McHugh Mark L. [mailto:mssqldba-ezmlmshield-x64919491.[Email address protected]
Sent: Friday, November 30, 2007 10:37 AM
To: LazyDBA Discussion
Subject: Identify SP3 versus SP3A

Anyone know how I can identify if a SQL 2000 server is running SP3 versus SP3A?



Mark McHugh
Georgia Pacific - Global Consumer Products IT
Business Intelligence - Specialty Analytics
 
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction."
Albert..



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page