Post reply

How to centralize your SQL Server Event Logs.

  • November 16, 2010 at 1:28 am

    #1251145

    Whoa! Very cool, Geoff. I've not done a deep dive on the code, yet, but I read the article. Very nicely done.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • December 1, 2010 at 1:41 am

    #1257191

    Geoff, thank you for sharing this information.

    i followed the given instructions as well as considered workarounds in case of error.

    all seems fine but i keep getting this vbscript error

    cannot open database "'DBA"' requested by login - the login failed

    code:80004005

    source microsoft OLE DB Provider for SQL Server

    (running sql2005 enterprise edition - logon mixed mode...)

    any suggestions are welcome

    ppcp

  • December 1, 2010 at 4:57 am

    #1257242

    Hi cppp,

    whatever account is running the VB Script will require access to your database DBA.

    So, if you followed the instructions, that means your SQL Server agent account is running the code.

  • December 1, 2010 at 10:35 pm

    #1257721

    Hi Geoff,

    thanks for your fast reply. In that case i must have overlooked something..

    i will give it another try

    cppp

  • January 3, 2011 at 11:47 am

    #1268599

    Your procedure is fantastic...! I congratulate you

  • July 25, 2011 at 7:48 am

    #1357774

    It worked fine in my SQL Server 2005 machine but I received the following error on my SQL Server 2008 machine.

    Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) Windows Script Host Version 5.6 Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.E:\Monitor\EventLog2DB.vbs(15, 1) SWbemServicesEx: Access denied. Process Exit Code 0. The step succeeded.

    Anybody any idea!?

  • November 4, 2011 at 11:10 am

    #1403402

    Did you ever write the article about the triggers and store procrdures because I don't find it anywhere?

  • April 2, 2012 at 10:38 am

    #1467724

    guillermob (11/4/2011)

    Did you ever write the article about the triggers and store procrdures because I don't find it anywhere?

    Ditto.

    I'd love to see what other tricks Geoff has up his sleeve.

  • April 2, 2012 at 11:28 am

    #1467760

    i know, in know.... i will eventually get to it. i promise. should be pretty simple since this is still the method i use for my alerting... thanks for the interest.

  • April 2, 2012 at 11:59 am

    #1467788

    Geoff A (4/2/2012)

    i know, in know.... i will eventually get to it. i promise. should be pretty simple since this is still the method i use for my alerting... thanks for the interest.

    That's great news!

    And thank you for such a detailed and useful article. You really saved me a lot of time and frustration.

    I look forward to the next installment.

  • May 15, 2012 at 3:24 pm

    #1488055

    great article....geoff i want IIS log events in this database...how can i do that???

    thanks in anticipation

  • May 15, 2012 at 4:04 pm

    #1488079

    With IIS 7.0' , it's super easy because you can choose a data sources to do this. It's a setting you have to install, but it's very straight forward.

    With IIS 6.0 or lower, it's another article.

  • May 16, 2012 at 1:56 am

    #1488221

    thank you for the prompt response...we have IIS 7.5....can you point me in the right direction what steps should i take to get IIS logs into our DBA database???

    thanks in anticipation

  • May 17, 2012 at 7:59 am

    #1489035

    help..!!!!

  • May 17, 2012 at 8:04 am

    #1489038

    will logparser work?

Viewing 15 posts - 31 through 45 (of 72 total)

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