Re: SQL Mail Logging

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Richard Ding (rding_at_acadian-asset.com)
Date: 08/27/04


Date: Fri, 27 Aug 2004 13:57:04 -0400

SQLmail is integrated with SQL so it is logged in sqlerrorlog. Other logs
you can check:
Windows event log
sql agent log
sqlagent.out in the sql log directory

"Gena Lakeman" <anonymous@discussions.microsoft.com> wrote in message
news:181701c48c56$aee58510$a301280a@phx.gbl...
> I am trying to troubleshoot an issue with SQLMail messages
> not being sent, but would like to check the SQL Mail Logs,
> but I cannot find any. I thought that SQL Svr. would
> write SQL Mail logs to c:\program files\Microsoft SQL
> Server\Log\SQL Mail, but no such file exists.
>
> Does anyone know how I can enable SQL mail logging on the
> server, or where I can find logs specifically pointed at
> SQL Mail?
>
> Thanks.
> Gena



Relevant Pages

  • Re: testing vulnerable web application.
    ... You should be able to just open up your logs and look for things that are out of the ordinary. ... Keep your database and all but double check it to make sure there really aren't accounts and what not that should not be there. ... We assumed the attacker was using some sort of SQL injection to alter the DB records or possibly he can craft a SQL query in a way that will create an admin account to use to simply log in and alter the records and then delete his username...NO rogue admin accounts have ever been found. ... You have an option to go with a managed service or an enterprise software. ...
    (Pen-Test)
  • Re: Unable to start SQL SERVER service for a SQL EXPRESS instance.
    ... Event Viewer, as you directed), so that's what that said. ... As for the SQL Error Log, there don't appear to be ANY logs. ... Now, it won't install completely. ...
    (microsoft.public.sqlserver.clients)
  • Re: Getting Started - RAID, Multiple Instances, SQL 2000-2005 . . .
    ... SQL 2000 Std. ... Data and Logs on RAID 5 partition ... Planning to put OS on RAID 1 partition, logs on different RAID 1 partition, ...
    (microsoft.public.sqlserver.setup)
  • Re: Does NTBackup backup SQL Express?
    ... In which case I assume the logs do NOT get flushed so this is not an option ... as I know enough that the logs must be flushed during every full backup. ... and the SBS server I regularly use runs MySQL not SQL ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Tracing Web service calls
    ... Message logs. ... I beleive IBM have created such a tool for their web service ... No SQL database blocking. ...
    (microsoft.public.dotnet.framework.aspnet)