Developer Forum

Hi,

How can I tell If my sql server is MSDN or Standard or Enterprise
version.

Thank you
AR

angsql ( XXXX@XXXXX.COM ) writes:

SELECT Serverproperty('Edition')


--
Erland Sommarskog, SQL Server MVP, XXXX@XXXXX.COM

Books Online for SQL Server SP3 at
http://www.yqcomputer.com/

But this command doesn't tell if it is
MSDN standard/enterprise version or retail standard/enterprise version.

.AR

SELECT @@VERSION


---
Mark Graveline
Take The Challenge
http://www.yqcomputer.com/
---

angsql ( XXXX@XXXXX.COM ) writes:

Functionally, there is no difference as far as I know. I guess that in this
case you need to review what licenses you have acquired. I believe there
are also different levels of MSDN, of which some entitles you for use in
production and others are not. Or I am thinking of Technet here?

--
Erland Sommarskog, SQL Server MVP, XXXX@XXXXX.COM

Books Online for SQL Server SP3 at
http://www.yqcomputer.com/

MSDN refers to the licence/subscription rather than the software
itself, so this isn't something SQL Server can tell you AFAIK.

--
David Portas
SQL Server MVP