I am on SQL 2005. How can I determine what type of SQL 2005 I have (workgroup
v/s express v/s standard).

I am told that my SQL 2005 is workgroup edition but when I go to the
properties of the SQL instance, it shows up as Microsoft SQL Desktop Engine
under the product field. I am confused.

Thank you.

SELECT SERVERPROPERTY('Edition');

Desktop Engine does not sound like 2005, it sounds like 2000 (specifically,
MSDE).





"Jack" <Jack@discussions.microsoft.com> wrote in message
news:2FB07521-89B8-4A1D-BD81-9A2264ED935F@microsoft.com...
>I am on SQL 2005. How can I determine what type of SQL 2005 I have
>(workgroup
> v/s express v/s standard).
>
> I am told that my SQL 2005 is workgroup edition but when I go to the
> properties of the SQL instance, it shows up as Microsoft SQL Desktop
> Engine
> under the product field. I am confused.
>
> Thank you.