All SQL Version info in one function

By Wilfred van Dijk, 2012/05/28

Just run the code in the database you want and add the following in your T-SQL scripts:

select * from dbo.udf_SQLVersionInfo()

This returns several columns. If you just want to check on a version number, you could run:

if (select ProductValue from dbo.udf_SQLVersionInfo()) > 10.0 ...

update: removed licensetype, support for MSSQL 2000, added HadrStatus, Isclustered and FulltextInstalled

Rate this
Join the discussion
Add to briefcase

Total article views: 2902 | Views in the last 30 days: 21

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

All SQL Version info in one function

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: