The script is updated to get the integer value of the major version number; instead of comparing the varchar values. also, this script will work for all the future versions of SQL Servers until there is paradigm shift in how SQL Server stores this information. Please let me if you have any problems using the script.
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".
)Forum Etiquette: How to post data/code on a forum to get the best help