SQL Version? | SQL Server Performance Forums

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"
Frank Kalis
Microsoft SQL Server MVP
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
. HTH Satya SKJ
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"