Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    México City
    Posts
    31

    Unanswered: DB size and used space?

    Do you know where I can get allocated and used space for one database?
    I've already got allocated space from sp_helpdb, but can't find any reference to used space.
    Thanks in advance,
    César.

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Post Re: DB size and used space?

    RE:
    Q1 Do you know where I can get allocated and used space for one database? I've already got allocated space from sp_helpdb, but can't find any reference to used space. Thanks in advance, César.
    A1 Yes.

    One way to determine allocated and used DB space is to use the special stored procedure sp_SpaceUsed, for example:

    Use Pubs
    -- Entire Pubs DB:
    Exec sp_SpaceUsed
    @updateusage = 'True'
    Go

    -- Authors table only:
    Exec sp_SpaceUsed
    @objname = 'Authors',
    @updateusage = 'True'

Posting Permissions

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