Results 1 to 4 of 4

Thread: SQL Upgrade

  1. #1
    Shaun Guest

    SQL Upgrade


    Ok, Ive worked out that my current SQL 6.5 is

  2. #2
    Shaun Guest

    SQL Upgrade (reply)


    Ok, Ive worked out that my current SQL 6.5 is
    CharSet 1, ISO_1 and sort order = 52


    What do I need to do to match SQL 7.o for the upgrade?

  3. #3
    rsp Guest

    SQL Upgrade (reply)

    Case-insensitive dictionary sort order

    This should be the default on SQL 7.0 install. Select custom install which allows you to control the installation settings - run an sp_helpsort from Query Analyzer in 7.0 to confirm.
    Case-insensitive dictionary sort order
    Let me know if this helps.
    ------------
    Shaun at 9/14/00 11:38:28 AM


    Ok, Ive worked out that my current SQL 6.5 is
    CharSet 1, ISO_1 and sort order = 52


    What do I need to do to match SQL 7.o for the upgrade?

  4. #4
    Shaun Guest

    SQL Upgrade (reply)

    Thanks for your help - your a star!!

    Installed fine, next challenge to upgrade dbs!



    ------------
    rsp at 9/14/00 2:02:14 PM

    Case-insensitive dictionary sort order

    This should be the default on SQL 7.0 install. Select custom install which allows you to control the installation settings - run an sp_helpsort from Query Analyzer in 7.0 to confirm.
    Case-insensitive dictionary sort order
    Let me know if this helps.
    ------------
    Shaun at 9/14/00 11:38:28 AM


    Ok, Ive worked out that my current SQL 6.5 is
    CharSet 1, ISO_1 and sort order = 52


    What do I need to do to match SQL 7.o for the upgrade?

Posting Permissions

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