Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151

    Exclamation Unanswered: sp_helpdb not working plz help

    Well i have been using sp_helpdb 'mydatabasename' to get the info for 3 consecutive days now and it returns the same result every day in KB for data files and in MB overall database size. Wich is kinda impossible since this is a warehouse and there are about 30000 records insert every night what is going on. plz help

  2. #2
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    USE

    EXEC sp_spaceused

    OR

    EXEC sp_spaceused @updateusage = 'TRUE' -- This one can slow down the DB a little bit

    Tim S
    Last edited by TimS; 02-18-05 at 16:43.

Posting Permissions

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