Post reply

querying version of SQL server

  • August 25, 2005 at 1:27 pm

    #102741

    Which command using Query Analyzer will give you the version of SQL server and operating system

     

    Thanks.

  • August 25, 2005 at 1:32 pm

    #585155

    exec xp_msver







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 25, 2005 at 1:35 pm

    #585158

    you can also do a "SELECT @@VERSION" and set the QA tools - options - results - to display the results as "text"!







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 26, 2005 at 9:44 am

    #585486

    SELECT RTRIM(CONVERT(varchar,SERVERPROPERTY('productversion')))as Productversion,

    RTRIM(CONVERT(varchar,SERVERPROPERTY ('productlevel')))as Productlevel,

    RTRIM(CONVERT(varchar,SERVERPROPERTY ('edition'))) as Edition

    EXEC master.dbo.xp_msver

    Best regards
    karl

Viewing 4 posts - 1 through 3 (of 3 total)

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