Forum Replies Created

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

  • RE: How to centralize your SQL Server Event Logs.

    Geoff A (5/30/2012)


    try this script instead;

    query = "Select * from __InstanceCreationEvent" _

    & " " & "where TargetInstance isa 'Win32_NTLogEvent'" _

    & " " & "and (TargetInstance.Logfile = 'Application' or...

  • RE: How to centralize your SQL Server Event Logs.

    Geoff A (5/30/2012)


    Hi Phil,

    Only MSSQL logs will be forwarded to the central server. That is a SQL Server Agent function.

    SQL Server Agent will not forward non SQL Application log entries.

    The...

  • RE: How to centralize your SQL Server Event Logs.

    Hi Geoff,

    Thanks for the articles, they've been a great use and were easy to follow.

    I've followed through the tutorial and the EventLogStaging table is written to when using the RAISERROR...

  • RE: SQL Task variable truncated

    Hi,

    I was having the same problem and was pulling my hair out. I tried testing all of the string-esque variable types to make sure that SQL_VARCHAR was the right...

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