Post reply

SQL Server Log file viewer Filter how to exclude?

  • March 4, 2008 at 6:06 am

    #120324

    Hello,

    We turned on Auditing on SQL Server log and now it's difficult to investigate any issues looking to log file. Anyone from you knows a way how to exclude entries in log for example don't display Logon source?

    Thanks for ideas

    MCP ID# 1115468 Ceritified Since 1998
    MCP, MCSE, MCP+I, MCSE+I, MCSA,
    MCDBA SQL7.0 SQL 2000, MCTS SQL 2005

  • March 4, 2008 at 10:18 am

    #785056

    I do not think there is a direct method via the standard viewer. You can use xp_errorlogreader to display the error log and filter out what you do not want to see.

    Declare @ErrorLog Table (LogID int identity(1, 1) not null primary key,

    LogDate datetime null,

    ProcessInfo nvarchar(100) null,

    LogText nvarchar(4000) null)

    Insert Into @ErrorLog (LogDate, ProcessInfo, LogText)

    Exec master..xp_readerrorlog

    Select *

    From @ErrorLog

    --Where filter stuff out

    Order By LogID Desc


    My blog: http://jahaines.blogspot.com

  • March 5, 2008 at 12:45 am

    #785331

    Thanks a lot that's enough 🙂

    MCP ID# 1115468 Ceritified Since 1998
    MCP, MCSE, MCP+I, MCSE+I, MCSA,
    MCDBA SQL7.0 SQL 2000, MCTS SQL 2005

  • February 24, 2015 at 9:06 pm

    #1779792

    Great info; thanks. 🙂

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

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