How to: Translate your SQL Server Version

 

Today I want to share with you two useful links I've found to easily determine your SQL Server edition, product version, Service Pack and Patch level. They will save yourself a lot of time and a lot of headhake.

 

Step 1: Identify your SQL Server Version and Edition

https://support.microsoft.com/default.aspx/kb/321185

 

To determine which version of SQL is running, you have to run a simple Transact-SQL  statement against your instances.

 

The statement is (SQL 2005 or SQL 200): SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

 

(SQL 7.0 or SQL 6.5): SELECT @@VERSION

 

Step 2: Identify your SQL Server Patch Level

https://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

 

This is a really handy database of SQL Server versions for those of who want to know what possible vulnerabilities may exist in un-patched SQL Server systems. Useful to quickly have a match between Instance version and Patch level.