SQL version and service pack level

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

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

SQL version and service pack level

Rate Topic

Display Mode

Topic Options

Author

Message

Chris Musasizi

Posted Sunday, April 13, 2008 10:14 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 20, 2013 6:33 AM
Points: 109, Visits: 67

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

Post #484163

Mauve

Posted Thursday, April 24, 2008 6:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:31 AM
Points: 1,150, Visits: 1,860

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 »

Permissions