Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How to find the SQL server version from Query Analyser
How to find the SQL server version from Query Analyser
✍: Guest
Answer1
To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement:
SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)
The results are:
• The product version (for example, “9.00.1399.06?)
.
• The product level (for example, “RTMâ€).
• The edition (for example, “Enterprise Editionâ€).
For example, the result looks similar to:
9.00.1399.06 RTM Enterprise Edition
How to determine which version of SQL Server 2000 is running
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code:
SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)
The results are:
• The product version (for example, 8.00.534).
• The product level (for example, “RTM†or “SP2?).
• The edition (for example, “Standard Editionâ€). For example, the result looks similar to
:
8.00.534 RTM Standard Edition
Answer2
One can also use SELECT @@Version where the result would look like
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2014-10-08, 1464👍, 0💬
Popular Posts:
when should the volatile modifier be used? The volatile modifier is a directive to the compiler's op...
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...
Can you prevent a class from overriding ? If you define a class as “Sealed” in C# and “NotInheritab...
What is test metrics? Test metrics accomplish in analyzing the current level of maturity in testing ...
What are the different elements in Functions points? The different elements in function points are a...