Results 1 to 9 of 9

Thread: sql 6.5 version

  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Arrow Unanswered: sql 6.5 version Simple question No answer

    2 question

    How do i know whether my sql 6.5 is standard or enterprise ?
    (@ version does not work)

    from help it say version 6.50.201


    2) can standard version 6.5 be upgraded to enterprise edition 2000

    and enterprised verswion 6.5 be upgraded to standard editon 2000

    thanks
    Last edited by sjumma; 04-16-04 at 12:46.
    bigfoots

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't have an MS-SQL 6.5 server handy to test, but I'm 99.5% sure that if you execute:
    PHP Code:
    SELECT @@version 
    it will show either Standard or Enterprise in the resulting string. If you still have trouble, please post the output of the command and I'll see what I can do to help.

    -PatP

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The version number returned is 6.5 Gold that is with no Service pack.
    The latest and last service pack on 6.5 returned as : [6.50.479 479 6.5 Post SP5a].

    There is no edition upgrade available in the 6.5 version, only upgrade from 4.2 or 6.0 is available.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Oct 2003
    Posts
    232

    does not give answer

    When i run select @@version


    It gives me
    Microsoft sql 6.50-6.5.416 (Intel x86)


    About upgrade I mean i install 2000 and move the database 6.5 to this on new computer


    will moving standard edition 6.5 to enterprise edition 2000 cause problem?

    or moving enterprise edition 6.5 to standard edition 2000 cause problem?

    thanks
    bigfoots

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can use the upgrade wizard to move your data, etc. I think it was pretty grumpy about doing the jobs, but I think it got everything else pretty well.

    -PatP

  6. #6
    Join Date
    Oct 2003
    Posts
    232

    Arrow Version ????? 6.5

    still i cannot find whether i have an enterprise version or standard version on 6.5

    even after select @@version

    microsoft sql 6.50-6.50.416 (Intel x86)


    And can we move from standard 6.5 to enterprise 2000 ?

    or Enterprise 6.5 to standard 2000 ?
    Last edited by sjumma; 04-19-04 at 13:25.
    bigfoots

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't know a good (easy) way to determine whether your MS-SQL 6.5 is Standard or Enterprise. You can find it, I think in the SQL log file, or at worst in the registry.

    You can convert your data using the upgrade wizard (see my previous post). The MS-SQL 6.5 data converts nicely to either SQL 2000 Standard or Enterprise versions.

    Jobs don't convert well, due to the radically different model used to support autonomous tasks. I would recommend that you recreate them (it takes very little time).

    Stored procedures convert reasonably well, as long as they are "plain vanilla" stored procedures. Some vendors supplied stored procedures in odd forms, some shrouded, some without source at all. Those don't always convert. User written procedures should be no problem at all.

    -PatP

  8. #8
    Join Date
    Oct 2003
    Posts
    232

    nothing in log file or registry

    I cannot find anything in the registery or the log files(error logs u mean correct)


    Thanks i asked MIcrosoft support also with no result


    salim
    bigfoots

  9. #9
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to http://www.microsoft.com/technet/pro...y/sqlugrd.mspx and you can easily upgrade any 6.5 edition to SQL 2K Enterprise edition or so.

    http://www.sql-server-performance.co...er_upgrade.asp for best recommendations on upgrade practice.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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