Standard or Enterprise Edition

Last Post 24 Feb 2009 09:48 AM by Markus_SQL. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Markus_SQL
New Member
New Member

--
24 Feb 2009 09: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 09:48 AM
I got the answer...


SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Text


Acceptable Use Policy
---