Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: Data files size and Log files size

    Hi!
    I'm using SQL Server 2000!
    How to know then Data files size and Log files size by Store Procedures or Sql query?
    Thanks!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run SP_HELPFILE and SP_SPACEUSED to get to know the database space used.
    Refer BOL for additional information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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