RE: Remove user login audit from SQL Server Error log
From: John Bandettini (JohnBandettini_at_discussions.microsoft.com)
Date: 02/08/05
- Next message: Tom Moreau: "Re: Log Ship possible over different subnets in workgroup?"
- Previous message: KOdedra: "Log Ship possible over different subnets in workgroup?"
- In reply to: quackhandle1975_at_yahoo.co.uk: "Remove user login audit from SQL Server Error log"
- Next in thread: quackhandle1975_at_yahoo.co.uk: "Re: Remove user login audit from SQL Server Error log"
- Reply: quackhandle1975_at_yahoo.co.uk: "Re: Remove user login audit from SQL Server Error log"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 03:53:02 -0800
Scott
Right click on your server in EM and choose properties. Then go to the
security tab. Sounds like your Audit level is either all or success. You can
change it here to either none or failure (If you want to know who's been
trying to connect).
Hope this helps
John
"quackhandle1975@yahoo.co.uk" wrote:
> Hi,
>
> I have an issue with the SQL Server Error Logs for my SQL Server
> becoming too large, thus when trying to view them EM simply hangs for a
> day or so (seems like it anyway!)
>
> I have used sp_cycle_errorlog to split them up into smaller chunks,
> however when investigating the content of the logs many of the messages
> are "Login Succeeded for user..." A previous DBA set this level of
> auditing up and now it is not required. How do I go about removing
> this user audit?
>
> Thanks
>
> Scott
>
>
- Next message: Tom Moreau: "Re: Log Ship possible over different subnets in workgroup?"
- Previous message: KOdedra: "Log Ship possible over different subnets in workgroup?"
- In reply to: quackhandle1975_at_yahoo.co.uk: "Remove user login audit from SQL Server Error log"
- Next in thread: quackhandle1975_at_yahoo.co.uk: "Re: Remove user login audit from SQL Server Error log"
- Reply: quackhandle1975_at_yahoo.co.uk: "Re: Remove user login audit from SQL Server Error log"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
