Post reply

Disk Space

  • September 14, 2005 at 7:27 am

    #87638

    Is there a sp I can run that will return the amount of free hard disk space there is and is there a sp that can return the number of entries in Windows Event Viewer?

    Thanks

  • September 14, 2005 at 9:12 am

    #589751

    I've found the answer to one of my questions, for the hard disk space use:

    exec master.dbo.xp_fixeddrives

  • September 15, 2005 at 9:50 am

    #590202

    use exec master..xp_logevent message,your message

  • September 16, 2005 at 1:11 am

    #590438

    Hi,

    I believe that xp_logevent logs a message rather than returning existing messages. I have found xp_eventlog but cannot find any documentation relating to it. Does anyone know what this sp does?

    Thanks

  • September 16, 2005 at 2:43 am

    #590459

    Another option is to use FSO within the SP to return the Size and Free Space on the disks, useful when you're after values from more than one server.

  • September 16, 2005 at 3:00 am

    #590463

    Hi,

    Do you have an example of the FSO syntax that I could use please?

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply