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 12»»

Ways to Determine the Version and SP of SQL Server Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2003 12:00 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, July 3, 2014 1:41 AM
Points: 175, Visits: 106
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/versionservicepack.asp
Post #10250
Posted Wednesday, February 26, 2003 10:55 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:51 AM
Points: 269, Visits: 132
The article was good.

Of all the ways,
SELECT SERVERPROPERTY('ProductLevel')
would be of much use as it tells what SP you are running, which most people want rather than version number.

And there is one more way to find this along with version number is Enterprise Manager.
If you right click on the Server (in EM), on the General tab you would see 'product version', which would tell you which service pack and version number you are running.





Post #55051
Posted Wednesday, February 26, 2003 11:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 1, 2013 6:04 PM
Points: 2, Visits: 17
Unfornuately SELECT SERVERPROPERTY('ProductLevel') does not work in SQL Server 7.0




Post #55052
Posted Thursday, February 27, 2003 12:06 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, July 3, 2014 1:41 AM
Points: 175, Visits: 106

Hi kmsonti,

Thanks for comment.

Though we can easily find the SP through EM, I always like this way as I am T-SQL junkie.

Anyway, thank you very much because you have added what I have missed.


mcp mcse mcsd mcdba
Post #55053
Posted Thursday, February 27, 2003 5:36 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 22, 2011 5:35 AM
Points: 1,758, Visits: 9
This is a great article. When Sapphire (SQL Slammer) hit our networking team went to every machine that even had SQLServer.exe (inside service packs or not) and shut them off the network. We had to prove to them we had the latest and greatest. With this tool it is a lot simpler because non-DBA's don't understand 8.00.760 is the latest they know SP3.

Thanks very much!

AJ Ahrens
SQL DBA
Custom Billing AT&T Labs




Good Hunting!

AJ Ahrens


webmaster@kritter.net
Post #55054
Posted Friday, February 28, 2003 9:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:50 AM
Points: 215, Visits: 43
ProductLevel is nice to know about when you don't have a version list handy. Thanks for the tip. Too bad it doesn't display hotfix level info too.




Post #55055
Posted Sunday, March 2, 2003 8:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 8:17 AM
Points: 298, Visits: 335
Sounds like a great article and tip.... Until you go to try it all out and you find that most of it doesn't work in SQL 7. It would be nice if folks would mention what version they based their work on at the start of the article.

Student of SQL and Golf, Master of Neither



Student of SQL and Golf, Master of Neither
Post #55056
Posted Monday, March 3, 2003 1:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:46 AM
Points: 15, Visits: 84
What about Enterprise Manager client?

What is the easiest way to determine the the EM client. The "About" tells you Microsoft Management Console version/build. Is there a method of determining the latest version is installed?

Thanks for the quick summary in your article.




Post #55057
Posted Thursday, March 6, 2003 6:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 11:58 AM
Points: 1, Visits: 22
IHMO using c:\winnt\system32\qfecheck.exe is also a valid way to discover the information needed.




Post #55058
Posted Monday, March 1, 2004 1:54 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:02 PM
Points: 2,892, Visits: 1,785
I thought hotfix 8.00.818 which is supposed to be the SQL Slammer patch?

LinkedIn Profile
Newbie on www.simple-talk.com
Post #103245
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse