SQLserver table probs

Results 1 to 5 of 5
  1. #1
    Account Upgraded | Title Enabled! Tilk is offline
    MemberRank
    Mar 2003 Join Date
    1,421Posts

    SQLserver table probs

    on Magic table ive added like 6 new rows at the same time n then it shows like <NULL> many values.

    Looks like ive added so many at once that it doesnt let me modify the <Null> value n cant remove the added rows either, so how can i remove or modify em >.<

    thx


  2. #2
    Member mrbob2 is offline
    MemberRank
    Mar 2003 Join Date
    Nottingham TrenLocation
    65Posts
    whats happened is that you have duplicated the magic's, i've done this before but i could not find a way to put everything back to normal, the only way i found to sort it out was to delete the whole of magic/monster/stditems table, and instate them back in >.<.

    sorry, and unless someones found away to sort this then your Database needs re-doing
    Last edited by mrbob2; 20-06-04 at 03:14 PM.

  3. #3
    Account Upgraded | Title Enabled! Tilk is offline
    MemberRank
    Mar 2003 Join Date
    1,421Posts
    well ive tried to replace my DB with the wirgin 1 from msrf2.9, but dunno y it still keeps all the stuff i added O.o

  4. #4
    Valued Member wond is offline
    MemberRank
    Jun 2003 Join Date
    123Posts
    Quote Originally Posted by Tilk
    well ive tried to replace my DB with the wirgin 1 from msrf2.9, but dunno y it still keeps all the stuff i added O.o

    Did you delete your old tables before restoring again? If not, then try delete them first.

  5. #5
    Account Upgraded | Title Enabled! Tilk is offline
    MemberRank
    Mar 2003 Join Date
    1,421Posts
    there isnt some way 4 take the tables out, create new ones n the copy paste all the stuff that i wish from my old tables?



Advertisement