Is this MSDE or full SQL Server?

Does anyone know if there is a way to determine if the SQL Server
installation being run is MSDE or SQL Server
Standard/Professional/Enterprise?

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Lee Mellinger" <lmellinger@.objacct.com> wrote in message
news:40155a1c$0$70304$75868355@.news.frii.net...
> Does anyone know if there is a way to determine if the SQL Server
> installation being run is MSDE or SQL Server
> Standard/Professional/Enterprise?
> Thanks!
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

select serverproperty('Edition')

Simon