Monday, March 26, 2012

Script to find out what Edition of SQL Server is installed

Does anyone have a quick script or method to verify the edition that is inst
alledHi,
Execute the below statement from Query Analyzer,
Select @.@.version
Thanks
Hari
MCDBA
"Glenn Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:A7DB397B-B431-47A8-8B43-7598EC5140BB@.microsoft.com...
> Does anyone have a quick script or method to verify the edition that is
installed|||http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Glenn Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:A7DB397B-B431-47A8-8B43-7598EC5140BB@.microsoft.com...
> Does anyone have a quick script or method to verify the edition that is
installed|||Found it, FYI
SELECT SERVERPROPERTY('productversion'),
SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')

No comments:

Post a Comment