Post reply

get table-size

  • March 9, 2010 at 4:50 am

    #75556

    Hello everybody,

    since I didn't found anything for my problem yet, I wonder if somebody can help me out here.

    Is there a way to read out the useage of databases? So the result might show information like the dbcc sqlperf(logspace) does for the logging functionality?

    Thanks in advance

    sd

  • March 9, 2010 at 5:08 am

    #1130558

    exec sp_spaceused

    Called without parameters it gives details for the DB as a whole, when passed a table name gives details for that table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 9, 2010 at 5:32 am

    #1130569

    thank you very much, that was exactly what I needed 🙂

    Cheers

    sd

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

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