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')

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 installedHi,
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, FY
SELECT SERVERPROPERTY('productversion')
SERVERPROPERTY ('productlevel')
SERVERPROPERTY ('edition'

Script Component - Code not saving after edit

I have SQL Server 2005 Developer Edition. I have a script component in one dataflow which I have added code to today. I saved using the save Icon and exited. I noticed a warning on the item, so I went back into the script and my changes had gone. I though I could not of saved the code and retyped, saving every 5 minutes. I closed visual studio, and noticed the script component had the warning on again! I went back to the code and all my changes were gone. I did not see any errors or warnings in Visual Studio. What am I missing, retyping code becomes tedious!Forgive me if this is obvious to you, but you have to click OK from the script transformation editor to save your code. Clicking the save button in the VSA Editor doesn't do anything useful.
|||

Thanks for the reply.

I did click OK each time. I deleted the Script object and started again, no problems with the new component. Just one of those Microsoft mysteries I think!