Which SQL Product version do you have?
Posted on March 1st, 2006 by humancamcorder
Today, i needed to find out which version of the Microsoft SQL software i had running in one of our servers. My client needed the enterprise version. I suddenly realized that i dont know how to quickly verify this information.
The quick answer is to use sql query analyzer and enter this sql code:
select SUBSTRING(@@VERSION,122,18) AS ‘PRODUCT edition’
This wasnt an original idea of mine. I got this by googling for it, and found this very effective sql script by Dinesh ..Oh yeah, the version i got is “Enterprise…”
Filed under: Computing
