Find your Sql Server Version and Edition
When working with Sql Reporting Services or other features that are version-specific, I often need to know what version of Sql Server is running on the target server.
For Sql 2000 and newer, you can simply query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
For Sql 7.0 and earlier, you can query:
If the results arent obvious, you can see this KB article for details on what each result means:
http://support.microsoft.com/kb/321185