If you ever wanted to know what version of Microsoft SQL Server and Edition you are running then Microsoft is maintaining really nice knowledgebase on this subject.
For SQL Server 2000 and later, use following SQL query to check the version and edition..
SELECT SERVERPROPERTY(‘productversion’) as Version, SERVERPROPERTY (‘productlevel’) as SP, SERVERPROPERTY (‘edition’) as Edition
For SQL Server 7.0 and earliar, use following SQL query to check the version. Please note that do not use this command on the SQL Server 2000 and later. It may return the information but may incorrect at times.
Look at the Microsoft KB article for more detailed information.