SQL version and service pack level

  • Chris Musasizi

    SSC Veteran

    Points: 293

    Comments posted to this topic are about the item SQL version and service pack level

  • Mauve

    SSChampion

    Points: 11316

    1. Should use ServerName property of SERVERPROPERTY vs. @@SERVERNAME as it is more accurate. See Remarks section under @@SERVERNAME in BOL.

    2. Ideally, when reporting the version of SQL Server you should also select the numerical ProductVersion property of SERVERPROPERTY. The "SP2" designation returned by ProductLevel does not indicate any special patches, etc.

    3. I wouldn't trust the parsing of @@VERSION. Microsoft could change the format in the future, thus breaking the logic.


    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply