Standard or Enterprise Edition

Last Post 24 Feb 2009 10:48 AM by Markus_SQL. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Markus_SQL
New Member
New Member

--
24 Feb 2009 10:41 AM
In SQL 2000:

I run this but it does not give me info on Standard or Ent. Edition of SQL Server. It states Standard or Ent of WIndows but not SQL Server.

SELECT @@ServerName AS Server,
LEFT(@@version, 26) AS Version
SELECT @@VERSION

SELECT
SERVERPROPERTY('productversion'),
SERVERPROPERTY('productlevel')
Markus_SQL
New Member
New Member

--
24 Feb 2009 10:48 AM
I got the answer...


SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Text
You are not authorized to post a reply.

Acceptable Use Policy