Sunday, August 14, 2005
To find what SQL product running....
DBAs often need to find the version of SQL Server running in a box. To find the result, we usually use "SELECT @@version" T-SQL command.
An un-noticed command to find the SQL Server verion is...
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
To get additional information to find SQL Server version, visit:
MSKB article
http://support.microsoft.com/?kbid=321185 and
http://vyaskn.tripod.com/sqlsps.htm
An un-noticed command to find the SQL Server verion is...
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
To get additional information to find SQL Server version, visit:
MSKB article
http://support.microsoft.com/?kbid=321185 and
http://vyaskn.tripod.com/sqlsps.htm
# posted by Satheesh Chandra @ 3:27 AM 
