Ways to Determine the Version and SP of SQL Server

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 Dinesh Priyankara » Ways to Determine the Version and SP of SQL...

16 posts, Page 1 of 2

1 2 »»

Ways to Determine the Version and SP of SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Dinesh Priyankara

Posted Wednesday, February 26, 2003 12:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174, Visits: 95

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/versionservicepack.asp

Post #10250

kmsonti

Posted Wednesday, February 26, 2003 10:55 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:15 AM
Points: 269, Visits: 108

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

plapic

Posted Wednesday, February 26, 2003 11:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, July 19, 2012 6:26 PM
Points: 2, Visits: 16

Unfornuately SELECT SERVERPROPERTY('ProductLevel') does not work in SQL Server 7.0

Post #55052

Dinesh Priyankara

Posted Thursday, February 27, 2003 12:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174, Visits: 95

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

AJ Ahrens

Posted Thursday, February 27, 2003 5:36 AM

SSCommitted

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

efelito

Posted Friday, February 28, 2003 9:35 AM

SSC Veteran

Group: General Forum Members
Last Login: Saturday, May 12, 2012 8:26 PM
Points: 215, Visits: 33

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. Sad

Post #55055

BobAtDBS

Posted Sunday, March 02, 2003 8:46 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, October 10, 2011 2:00 PM
Points: 297, Visits: 329

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

kellington

Posted Monday, March 03, 2003 1:22 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 26, 2013 2:04 PM
Points: 15, Visits: 72

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

proverbs53

Posted Thursday, March 06, 2003 6:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 19, 2008 4:22 AM
Points: 1, Visits: 14

IHMO using c:\winnt\system32\qfecheck.exe is also a valid way to discover the information needed.

Post #55058

David.Poole

Posted Monday, March 01, 2004 1:54 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:16 PM
Points: 2,749, Visits: 1,405

I thought hotfix 8.00.818 which is supposed to be the SQL Slammer patch?

LinkedIn Profile

Post #103245

« Prev Topic | Next Topic »

16 posts, Page 1 of 2

1 2 »»

Permissions