Post reply

transaction log monitoring

  • December 3, 2006 at 11:28 pm

    #68557

    Is there a way to monitor the transaction log from a remote location? I'm thinking of an e-mail notification wherein the server would send me e-mails telling me the size of my transaction log and maybe even the database size.

    sp_sendmail is counted out because we are not using MS exchange and i'm having major difficulties setting up MAPI profiles.

    So..is this possible?!

    cause i'm tired of accessing my servers through a remote control application(which took a very long time just to connect). So, just checking your logs would take at least 20 - 30 mins.

  • December 4, 2006 at 3:40 am

    #675405

    If you look in the scripts sections , there are alternate ways of sending mail with SQL2000 as long as you have an SMTP server somewhere you could use ( doesn't have to be exchange ).

    you'd just want to possibly dump some of the results from sp_helpdb into the body of a mail.

     

Viewing 2 posts - 1 through 1 (of 1 total)

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