Home Forums SQL Server 2005 SQL Server Express Installed sp4 to SQL Server Express 2005 but @@version shows Build 2600 Server Pack 3. RE: Installed sp4 to SQL Server Express 2005 but @@version shows Build 2600 Server Pack 3.

  • March 29, 2011 at 10:52 am

    #1305030

    Thanks to all for the fast response to my question.

    It was extremely helpful.

    I also came across the following t-sql that displays "SQL Server 9.00.5000.00 - SP4 (Express Edition).

    SELECT 'SQL Server '

    + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '

    + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('

    + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

    Howard