Post reply

Ways to Determine the Version and SP of SQL Server

  • February 26, 2003 at 12:00 am

    #105469

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

  • February 26, 2003 at 10:55 pm

    #449838

    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.

  • February 26, 2003 at 11:41 pm

    #449839

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

  • February 27, 2003 at 12:06 am

    #449840

    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

  • February 27, 2003 at 5:36 am

    #449871

    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

  • February 28, 2003 at 9:35 am

    #450046

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

  • March 2, 2003 at 8:46 pm

    #450102

    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

  • March 3, 2003 at 1:22 pm

    #450158

    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.

  • March 6, 2003 at 6:25 am

    #450392

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

  • March 1, 2004 at 1:54 am

    #496401

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

    LinkedIn Profile

  • March 31, 2004 at 11:08 am

    #501341

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

  • April 1, 2004 at 12:57 am

    #501409

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

    INSERT #MyTable(<fields>

    exec master.dbo.xp_msver

     

    LinkedIn Profile

  • May 28, 2004 at 2:26 am

    #508133

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

     

    Kindest Regards,

    karthik

  • October 18, 2005 at 5:31 am

    #597881

    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

     

  • May 3, 2007 at 2:51 am

    #704017

    very informative

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply