Re: Filter SQL Server Errorlog
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/06/04
- Next message: Willem Grobbelaar: "deny alter table access"
- Previous message: Mingqing Cheng [MSFT]: "Re: Demo Alerts in MS SQL do they cover every problem ?"
- In reply to: Hong Wang: "Filter SQL Server Errorlog"
- Next in thread: Kevin McDonnell [MSFT]: "Re: Filter SQL Server Errorlog"
- Reply: Kevin McDonnell [MSFT]: "Re: Filter SQL Server Errorlog"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 6 Aug 2004 11:09:17 +0100
Ideally, you would have to write a program to scan the error log and prepare
the report.
Here's something undocumented, so don't count on it to work on every version
of SQL Server. The following code can look for all entries in the error that
have the word 'Login' in them.
EXEC sp_readerrorlog 1, 'G:\MSSQL\Log\errorlog', 'Login'
More info at: http://vyaskn.tripod.com/sp_readerrorlog_undocumented.htm
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ "Hong Wang" <HongWang@discussions.microsoft.com> wrote in message news:148AC284-414D-4E5D-B976-0AC267089D4C@microsoft.com... Hi, I have a SQL Server that turned on to audit login failure. For our security auditing purpose, I need to print out the error log that shows which user has a login failure. But the errorlog is too long, and I need to print out a new log every week. Is there a way that I can filter out only the login failure records in the errorlog and print them out? Thanks.
- Next message: Willem Grobbelaar: "deny alter table access"
- Previous message: Mingqing Cheng [MSFT]: "Re: Demo Alerts in MS SQL do they cover every problem ?"
- In reply to: Hong Wang: "Filter SQL Server Errorlog"
- Next in thread: Kevin McDonnell [MSFT]: "Re: Filter SQL Server Errorlog"
- Reply: Kevin McDonnell [MSFT]: "Re: Filter SQL Server Errorlog"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
Loading
