Home Forums Article Discussions Article Discussions by Author Discuss content posted by Chris Musasizi SQL version and service pack level RE: SQL version and service pack level

  • 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]