Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Thumbs up Unanswered: How to find out the SQL server version?

    Dear Friends,

    I have SQL Script....

    How to find out the Sql Server version?


    PLease let me know...

    Thanks,
    Arthi

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    To get edition on a SQL 2k box - select serverproperty('edition')

    To get service pack level on SQL2k box - select serverproperty('productlevel')

    For SQL 7 box - select @@version

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Aug 2003
    Posts
    4

    Version

    Thanks for your reply...

    I have only the SQL Script....

    How to find out the SQL Server version....


    Thanks,
    Arthi

  4. #4
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You have only the SQL script...what does that mean?

    Do you mean you have some SQL code and you are trying to figure out what version it was written for? If so that will be difficult as most code that will work for SQL 6.5 will work on SQL 2000 but there are additional keywords for SQL2K and SQL 7 that would not work for 6.5. If this is what you are looking for, feel free to post your code and see if anyone can figure it out, if I am still not understanding your question, please provide more details for what you need.
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  5. #5
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Hi

    Like he said .. very hard to look and tell from scripts.Unless you mean SQL Query tool .. you can use Select @@version command

Posting Permissions

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