SQLServerCentral / Discuss Content Posted by Dinesh Priyankara / Article Discussions / Article Discussions by Author / Ways to Determine the Version and SP of SQL Server / Latest Posts

RE: Ways to Determine the Version and SP of SQL Server

Zaheer-354434 — Mon, 14 May 2007 06:26:00 GMT

Lovely and Brilliant short notes, Help alot....

RE: Ways to Determine the Version and SP of SQL Server

raghavendra bhat-392970 — Thu, 03 May 2007 02:51:00 GMT

very informative

RE: Ways to Determine the Version and SP of SQL Server

Rama Chandra Gowtham. Peddada — Tue, 18 Oct 2005 05:31:00 GMT

Thanks, for the information provided. but it will be a great help if anyone could send a list of patches released and what patches are included in the service pack

Thanks In Advance

Gowtham

RE: Ways to Determine the Version and SP of SQL Server

karthikeyan-146504 — Fri, 28 May 2004 02:26:00 GMT

Thanks, Very useful to find the version and sp of sqlserver

RE: Ways to Determine the Version and SP of SQL Server

David.Poole — Thu, 01 Apr 2004 00:57:00 GMT

CREATE TABLE #MyTable(<column name> <column Type> , etc)

INSERT #MyTable(<fields>exec master.dbo.xp_msver

RE: Ways to Determine the Version and SP of SQL Server

Jaime E. Maccou — Wed, 31 Mar 2004 11:08:00 GMT

Great article. I do have a question; how can I output the results from master..xp_msver production to a table?

RE: Ways to Determine the Version and SP of SQL Server

David.Poole — Mon, 01 Mar 2004 01:54:00 GMT

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

RE: Ways to Determine the Version and SP of SQL Server

proverbs53 — Thu, 06 Mar 2003 06:25:00 GMT

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

RE: Ways to Determine the Version and SP of SQL Server

kellington — Mon, 03 Mar 2003 13:22:00 GMT

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.

RE: Ways to Determine the Version and SP of SQL Server

BobAtDBS — Sun, 02 Mar 2003 20:46:00 GMT

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

RE: Ways to Determine the Version and SP of SQL Server

efelito — Fri, 28 Feb 2003 09:35:00 GMT

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. :(

RE: Ways to Determine the Version and SP of SQL Server

AJ Ahrens — Thu, 27 Feb 2003 05:36:00 GMT

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 AhrensSQL DBACustom Billing AT&T Labs

RE: Ways to Determine the Version and SP of SQL Server

Dinesh Priyankara — Thu, 27 Feb 2003 00:06:00 GMT

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

RE: Ways to Determine the Version and SP of SQL Server

plapic — Wed, 26 Feb 2003 23:41:00 GMT

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

RE: Ways to Determine the Version and SP of SQL Server

kmsonti — Wed, 26 Feb 2003 22:55:00 GMT

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.

Ways to Determine the Version and SP of SQL Server

Dinesh Priyankara — Wed, 26 Feb 2003 00:00:00 GMT

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