Re: The error log that ate the server!!!!!
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/27/04
- Next message: Wayne Snyder: "Re: SQL Mail using client other than Outlook Full Version / SQL Mail using outlook express"
- Previous message: Wayne Snyder: "Re: Is there something wrong with my IF code..."
- Maybe in reply to: Hari Prasad: "Re: The error log that ate the server!!!!!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 07:30:23 -0400
You can do this in profiler, but I suspect it would be more efficient to do
it as you are... There is no way to filter outside of profiler, short of
writing some program that would read/re-write the log after you have cycled
it...
You might also check your NT application log, that is probably growing due
to this also..
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Cathy Finnegan" <eliminates_spam_caeriel1@cablespeed.com> wrote in message news:q7oag0pvd049flbkhlb40q56dp3cv4mhkd@4ax.com... > I'v got a vexing problem. I've been able to implement a SQLServer Agent job that launches every 20 seconds. The > function of this job is to kick off illegal users using a specified userid. Since I can't intercept the login the best I > can do is to terminate illegal users before they can get into my databases.... Job launches every 20 seconds and > performs exactly as expected. > > The problem I'm having is the job logs in as "sa" every 20 seconds, I set my security audit level to all so this job is > blowing up my error log. I want to be able to monitor other logins and events so setting the audit level to something > less than "all" is not desirable. Is there some way I can selectively eliminate a specific login from being monitored > and ending up in the error log?? > > Right now I'm cycling the error log every 12 hours just to keep it manageable > > SQL Server 7 on Windows NT 4. > > > Any help or suggestions is greatly appreciated. > > TIA, > cathy
- Next message: Wayne Snyder: "Re: SQL Mail using client other than Outlook Full Version / SQL Mail using outlook express"
- Previous message: Wayne Snyder: "Re: Is there something wrong with my IF code..."
- Maybe in reply to: Hari Prasad: "Re: The error log that ate the server!!!!!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
