Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL version and service pack level Expand / Collapse
Author
Message
Posted Sunday, April 13, 2008 10:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 24, 2013 7:29 AM
Points: 109, Visits: 74
Comments posted to this topic are about the item SQL version and service pack level
Post #484163
Posted Thursday, April 24, 2008 6:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:03 AM
Points: 1,182, Visits: 1,970
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.



(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.
Post #489873
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse