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
[...] Humancamcorder, a certified techie and Google Adwords Qualified Individual gave a tip on finding out the version of the Microsoft SQL software you are using. [...]
Using substring in your query will limit your output… Although you could get a portion of the version info (in your case “Enterprise…” — SQL 2000 EE, in my case “on Developer Edit” — SQL 2005 Dev Ed) you might not get the info you need since not all versions of SQL Server output their version info on the 122nd character of the result set when you query @@version.
Using “Select @@version” alone will do… Applicable on all editions of SQL Server versions 7, 2000 and 2005.