SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    get back to rowing khu19's Avatar
    Join Date
    Jan 2003
    Location
    New York / Boston
    Posts
    593
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb Check the size of MSSQL 2000 Database

    How can I check the size of my current database?

  2. #2
    SitePoint Wizard bronze trophy
    Join Date
    Apr 2003
    Posts
    4,095
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Uh... do you have physical access to the server? If so, just figure out where the database is stored and check its size.

    Oops, never mind: a little voice in the back of my head reminded me that you use Tokios, Khu.

  3. #3
    get back to rowing khu19's Avatar
    Join Date
    Jan 2003
    Location
    New York / Boston
    Posts
    593
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ha good memory! Yeah I'm using tokios. I mean this isn't a dire situation, I"m just at work and bored so I figure I'd see if I could find an answer to this.

  4. #4
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sp_helpdb yourDB

    I'm pretty sure that stored procedure still exists.

    You could do magic and select from sysdatabases, but the proc is far easier.

  5. #5
    get back to rowing khu19's Avatar
    Join Date
    Jan 2003
    Location
    New York / Boston
    Posts
    593
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cool thanks; I'll try it when I get home.


Bookmarks

Posting Permissions

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