Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    22

    Unanswered: Alert to notify when database reaches N' capacity

    I need to get a query that will allow me to select(the names) of all the DB's on a server into a table or even a Sproc to populate a #table with it.
    The plan is to use the query as a cursor and run EXEC sp_spaceused for each database.

    I'm trying to set up an alert that will notify me when a/any database on the server exceeds N' of its capacity..

    Any thoughts..?

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    xp_fixeddrives get's available disk space for each drive on server.

  3. #3
    Join Date
    Aug 2009
    Posts
    22
    Thanks, but still not giving me what i'm after.

    I need a script that I can use to notify me when any/all databases on a server upon which the script is executed, exceeds a certain parameter. Preferably a %of its maximum capacity...?

Posting Permissions

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