SQL Server Log file viewer Filter how to exclude?

• berto

  SSCommitted

  Points: 1878

  More actions

  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

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  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

• berto

  SSCommitted

  Points: 1878

  More actions

  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

• lightheartal

  SSC-Addicted

  Points: 434

  More actions

  February 24, 2015 at 9:06 pm

  #1779792

  Great info; thanks.