Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    27

    Wink Unanswered: Getting DB Size in a view

    How can I insert the size of the db in a select so I can include its value in a view?

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You can incorporate this with what you are doing, if this doesn't get you started, reply back

    select size
    from sysfiles
    where fileid = 1
    and name = dbname
    ---------------
    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
  •