• you have problem with the WMI object, not with the DB.

    what did you change with the code?

    query = "Select * from __InstanceCreationEvent" _

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

    & " " & "and TargetInstance.Logfile = 'Application'" _

    & " " & "and (TargetInstance.EventType = 1 or TargetInstance.EventType = 2)" _

    & " " & "and (TargetInstance.SourceName like 'MSSQL%')"

    ' get ready to insert into our DBA table

    the problem is when you try to run the query :

    Set colMonitoredEvents = objWMIService.ExecNotificationQuery(query)