SQL Server Transact-SQL (SSQA.net)

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Use the following TSQL 

SELECT SERVERPROPERTY('Collation')                          Collation,
              SERVERPROPERTY('Edition')                            Edition,
              SERVERPROPERTY('Engine Edition')                 EngineEdition,
              SERVERPROPERTY('InstanceName')                 InstanceName,
              SERVERPROPERTY('IsClustered')                      IsClustered,
              SERVERPROPERTY('IsFullTextInstalled')            IsFullTextInstalled,
              SERVERPROPERTY('IsIntegratedSecurityOnly')   IsIntegratedSecurityOnly,
              SERVERPROPERTY('IsSingleUser')                    IsSingleUser,
              SERVERPROPERTY('IsSyncWithBackup')           IsSyncWithBackup,
              SERVERPROPERTY('LicenseType')                    LicenseType,
              SERVERPROPERTY('MachineName')                 MachineName,
              SERVERPROPERTY('NumLicenses')                  NumLicenses,
              SERVERPROPERTY('ProcessID')                       ProcessID,
              SERVERPROPERTY('ProductVersion')                ProductVersion,
              SERVERPROPERTY('ProductLevel')                   ProductLevel,
              SERVERPROPERTY('ServerName')                    ServerName

To answer the second part of the question, best to refer to http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html link.