SQL Server Performance Forum – Threads Archive

SQL Version?

How can I find which version of SQL server is installed on my machine? Thanks!
"He laughs best who laughs last"

---

SELECT @@VERSION —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

---

I can just get tht its SQL SERVER 2000 but i want to know whether it is enterprise edition or developer or something else. Thanks!
"He laughs best who laughs last"

---

WHen you run that @@VERSION it returns Microsoft SQL Server 7.00 – 7.00.1094 (Intel X86)
May 29 2003 15:21:25
Copyright (c) 1988-2002 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
That means SQL is a standard edition or run
SELECT CONVERT(char(20), SERVERPROPERTY ( Edition ))
. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

ohh yeah I am sorry for bothering U, I cudnt see the complete result. I just copied and pasted, iam able to see it now. Thanks!
"He laughs best who laughs last"

---

]]>