Here’s a handy little script which tells you what version, service pack and edition of SQL Server you’re running.

It’s best to display results as “Text” rather than the “Grid”.

   SELECT   @@VERSION
   SELECT   RTRIM(CAST(SERVERPROPERTY('productversion') AS VARCHAR)) AS [Version],
            RTRIM(CAST(SERVERPROPERTY ('productlevel') AS VARCHAR)) AS [Level],
            RTRIM(CAST(SERVERPROPERTY ('edition') AS VARCHAR)) AS [Edition]