Post reply

MS SQL 2000 Version Numbers

  • December 4, 2006 at 1:29 am

    #193298

    Hi,

    Just want to ask the meanings of the SQL Versions when you typed

    select @@version

    my test server has the following output: 8.00.2049

    the other servers has the following output: 8.00.760

    Does the numbers differ per type of SQL Server? (SQL Standard, SQL Enterprise, SQL Personal, etc)

  • December 4, 2006 at 6:45 am

    #675431

    Not sure if you've fully expanded the results or not...but if you pick tools-options and select "results to text" under the results tab, you'll find it more readable and therefore more comprehensive....you can see then what edition is being used....

    you can go to this site for an informative chart on the build numbers and service packs.







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

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

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