Results 1 to 6 of 6

Thread: Need help with MS SQL Enterprise manager

  1. #1
    Variable Bitrate
    Join Date
    Nov 1999
    Location
    Ishoej, Denmark
    Posts
    310

    Post Need help with MS SQL Enterprise manager

    Does anyone know how you can edit ntext fields, when they exeed the 256 char limit that STILL EXISTS!! in MS SQL Enterprise manager.

    Im trying to edit several fields in several tables that use ntext fields with text often exceed the 256 chars. my only solution at pressent is using the query analyzer or map the tables in access, but it isnt what i really want, a quick and easy and FLEXIBLE program ...

    Tried searching the MS site but only found a load of cr*p.

    any one know of a fix (ie changes in the registry) or a program that works similarly to enterprise manager (change fields directly) that will coope with ntext fields above 256 chars ???

  2. #2
    Variable Bitrate
    Join Date
    Aug 2000
    Location
    Abbotsford, BC, Canada
    Posts
    441

    Post

    I asked our resident database expert... his reply:
    "That's the way that ntext is defined. Bang head against brick wall. Repeat if necessary."
    LOL!
    ~m
    PII 266, 512 MB RAM, 10 Gig, 36x CD-ROM, 16x DVD, DeLorme GPS, 5.6" LCD Screen, Dschmidt power controller, Keypower ATX DC-DC Supply, PowerAmp Macro controller, Dauphin mini-Kbd.
    Sony Head Unit, Sony Unilink input selector, rear deck Kenwood 6x9's, stock door spkrs... All in my '96 Civic, of course :}
    BC ROCKS!!!

  3. #3
    Variable Bitrate
    Join Date
    Nov 1999
    Location
    Ishoej, Denmark
    Posts
    310

    Post

    sigh, i was afraid of that ...

  4. #4
    Maximum Bitrate PoBoy's Avatar
    Join Date
    Jun 2001
    Location
    St. Louis-MO
    Posts
    490

    Post

    Dont use MSQL much, but why are you coding in unicode (ntext)?? Doesnt "text" alow you more space??

    If text is the same as ntext (which is shouldnt be, but we are talking about Microsoft, try using text pointers.

    There is a way to do it though.
    I'm a ghost...email me if you have any questions on my old setup

    My way outdated website: http://www.poboytech.net

    FYI: I sold my 96 4Runner and bought a 1985

  5. #5
    Maximum Bitrate
    Join Date
    Mar 2001
    Location
    Cincinnati, OH USA
    Posts
    694

    Post

    Try using memo fields instead of text fields. At least that is how I get past the 256 char limit in Access for my web databases.
    http://www.mp3car.com/usersites/Maveric/ M.A.V.I.C. System
    Asus MB, PII 266, 192 MB Ram, 6.8" LCD, 6 Disk CD-ROM, 21 Gig HD, All-in-Wonder Video w/ TV Tuner, Irman, Windows ME, Winamp, Cobra III -- All in a custom acrylic case.

    http://www.mp3car.com/usersites/listings/ MP3car Listings - Please add to it! :)

  6. #6
    Variable Bitrate
    Join Date
    Nov 1999
    Location
    Ishoej, Denmark
    Posts
    310

    Post

    ill test out thoose recommendations, thanks guys

Bookmarks

Posting Permissions

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