SQL Tips – Identifying which version of SQL Server you are using

Posted by John 7 February 2009 in SQL Tips

If you need to find out the version of SQL Server you are using, simply use the following script:

SELECT SERVERPROPERTY('productversion'),
       SERVERPROPERTY('productlevel'),
       SERVERPROPERTY('edition')

About the Author: John

Leave a Reply Cancel reply