Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: sql version and sp Pls Its urgent!!!!!!!!!

    hi all,

    Sql Server 7
    Pls can u give command where i can be able to find out the version and service pack of the servers which i am using.
    and also a script will when run would give the solution
    pls. its very urgent help me....

    TIA
    Adil

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    SELECT @@Version should tell you what version you are running ...
    Here are the version numbers for 7

    7.00.623 Original SQL Server 7.0 or MSDE 1.0 release
    7.00.699 SQL Server with SP1
    7.00.842 SQL Server with SP2
    7.00.961 SQL Server with SP3
    7.00.1063 SQL Server with SP4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •