SQL version and service pack level

• Chris Musasizi

  SSC Veteran

  Points: 295

  More actions

  April 13, 2008 at 10:14 am

  #379793

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

• Mauve

  SSChampion

  Points: 11316

  More actions

  April 24, 2008 at 6:55 am

  #806529

  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]