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
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
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.