Re: User_name on 229 error alert

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/20/05


Date: Wed, 19 Oct 2005 20:27:22 -0600

I think you'd need to capture that info in a trace or
profiler using the errors and warnings event classes, not in
an alert.

-Sue

On Tue, 18 Oct 2005 17:36:46 +0200, "LEO"
<leo.rocchi@infinito.it> wrote:

>On sql2K, I need the USER_NAME with alert on 229 error (%ls permission
>denied on object '%.*ls', database '%.*ls', owner '%.*ls'.)
>
>HOW ?
>Thanks
>



Relevant Pages

  • Re: Profiler Bug viewing trace flat file?
    ... The TextData column is definitely populated when I query resulting trace ... selected in Profiler and run from Profiler. ... declare @TraceID int ...
    (microsoft.public.sqlserver.tools)
  • Re: Profiler Bug viewing trace flat file?
    ... exec PostAvailableContractsCache_sp ... The TextData column is definitely populated when I query resulting trace ... selected in Profiler and run from Profiler. ...
    (microsoft.public.sqlserver.tools)
  • Re: Application Trace Profiler
    ... I have my debug event handling loop in a background thread, ... I tried this article and I was able to profile the Trace messages from my ... there any way to detach from the application so that the profiler can exit ... intercept the Trace statements of another running .NET application. ...
    (microsoft.public.dotnet.general)
  • Re: Profiler temp file
    ... Yes you are missing the whole point. ... Trace to a file without running profiler at all. ... shows how to create a script from scratch but if you follow my instructions ...
    (microsoft.public.sqlserver.tools)
  • Re: Application Trace Profiler
    ... I have my debug event handling loop in a background thread, ... I tried this article and I was able to profile the Trace messages from my ... there any way to detach from the application so that the profiler can exit ... intercept the Trace statements of another running .NET application. ...
    (microsoft.public.dotnet.general)