Post reply

Table space in databases

  • April 25, 2004 at 12:05 am

    #108015

    When I use sp_spaceused stored procedure to find out about number of rows, space reserved, index size and unused space left I see in index_size zero, unused space zero or minus number for some tables.  Database size shows lot of unused space. 

    What does this mean?  What I need to do?

    Please let me know.  Thank you for your help in advance.

     

  • April 26, 2004 at 1:06 am

    #504181

    Try running this statement against the databases in question.

     sp_spaceused @updateusage = 'TRUE'

  • November 19, 2004 at 8:26 am

    #530848

    I'm trying to use sp_spaceused in a custom stored procedure.. I have a cursor iterating over each table, and passing the tablename to sp_spaceused, but how do I compile all those results into a decent resultset, rather than getting separate resultsets for each table?

     

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply