Identify your SQL Server version and SP

--
--For SQL 6.5 or later
--
select @@version
go
sp_server_info
go

--
--For SQL 2000 or later
--
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
go