Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Negative reserved size

    My turn to ask a question.

    Running sp_spaceused on one of my tables yields a negative reserved size (-96 kb), and a corresponding negative unused size.

    The table has only 7 fields, all varchar, datetime, or int. No indexes or foreign keys. Under 2000 rows.

    I'm running 2000 with patches.

    Anybody see this before? I couldn't find anything about this on Microsoft's support site.

    blindman

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    If you run

    sp_spaceused tablename, true

    does the value change? the true forces sysindexes to be updated and reflected in what's returned.
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Thanks. That did it. I was not aware of that sp_spaceused parameter.

    Apparently, the sp_spaceused parameter defaults to "False"!

    blindman

  4. #4
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Yes it does, it really jsut runs a DBCC updateusage (I believe only against the table, it might be the database though) THat updates your sysindexes which is what spaceused relies on.

    Don't know how you got negative values in reserved though, I tried making it by doing bulk inserts into an new empty table but it gave me O for reserved until I ran the updateusage.
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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