A Question about MSSQL.

Results 1 to 13 of 13
  1. #1
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Post A Question about MSSQL.

    I want to reset all the accounts and characters in my database such that it seemed that they never existed. I want the AID's to start from 1 again , CharacterItem.dbo and all other Character info to be deleted. Could someone tell me how I could do so?


  2. #2

    Re: A Question about MSSQL.

    Delete the tables, and recreate them with the queries provided in the server tutorial.

    It should reset the AID(s).

  3. #3
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: A Question about MSSQL.

    DELETE * FROM Account
    DELETE * FROM Character
    I'm not sure about the AIDs
    Last edited by wesman2232; 13-08-09 at 03:08 AM.

  4. #4

    Re: A Question about MSSQL.

    Quote Originally Posted by wesman2232 View Post
    DELETE * FROM Account
    DELETE * FROM Character
    I'm not sure about the AIDs
    The AID count would not reset that way.

    Just drop the tables, and recreate them.

    Code:
    DROP TABLE Account
    DROP TABLE Character

  5. #5
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: A Question about MSSQL.

    I tried that query on both Tables Linear88, but it say's the table's are being used by a Foreign Key. And those key's dont even get deleted. Sorry, Idk MSSQL. What do I do?

  6. #6

    Re: A Question about MSSQL.

    Quote Originally Posted by phoenix_147 View Post
    I tried that query on both Tables Linear88, but it say's the table's are being used by a Foreign Key. And those key's dont even get deleted. Sorry, Idk MSSQL. What do I do?
    Drop the other tables which are preventing it from being dropped.

    Example:

    If you see:
    FK1_ITEM_92328340

    Where:
    randomidentifier_tablename_randomid

    Code:
    DROP TABLE tablename

  7. #7
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: A Question about MSSQL.

    I dont get it

  8. #8

    Re: A Question about MSSQL.

    Look into it. That's all.
    Last edited by Linear88; 13-08-09 at 03:07 PM.

  9. #9
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: A Question about MSSQL.


  10. #10

    Re: A Question about MSSQL.

    Never mind, just execute this into a query:

    Code:
    DROP TABLE AccountItem
    DROP TABLE ClanGameLog
    DROP TABLE ClanMember
    DROP TABLE GameLog
    DROP TABLE Item
    DROP TABLE Login
    DROP TABLE Account
    I won't go much into detail, but;

    If it doesn't work, just find out what's interfering with the statements provided.

  11. #11
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: A Question about MSSQL.

    I cant delete Item.dbo! All the cash item's are in it lol. Each and every x_x

    ---------- Post added at 03:58 PM ---------- Previous post was at 03:50 PM ----------

    ='(


  12. #12
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: A Question about MSSQL.

    Anyone :'(?

  13. #13

    Re: A Question about MSSQL.

    Remove the foreign key constraints, however, it may cause problems.



Advertisement