How can I tell if a sql server is MSDN or Standard or Enterprise version

How can I tell if a sql server is MSDN or Standard or Enterprise version

Post by angsq » Sat, 05 Nov 2005 07:33:42


Hi,

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

Thank you
AR
 
 
 

How can I tell if a sql server is MSDN or Standard or Enterprise version

Post by Erland Som » Sat, 05 Nov 2005 08:12:34

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/

 
 
 

How can I tell if a sql server is MSDN or Standard or Enterprise version

Post by angsq » Sat, 05 Nov 2005 10:23:31

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

.AR
 
 
 

How can I tell if a sql server is MSDN or Standard or Enterprise version

Post by SQLChallen » Sat, 05 Nov 2005 12:11:57

SELECT @@VERSION


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

How can I tell if a sql server is MSDN or Standard or Enterprise version

Post by Erland Som » Sat, 05 Nov 2005 17:25:02

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/
 
 
 

How can I tell if a sql server is MSDN or Standard or Enterprise version

Post by David Port » Sat, 05 Nov 2005 18:04:50

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