Re: Forcing a trace to start when SQL Server starts

From: Patricia (pat777@hotmail.com)
Date: 06/25/02 

From: "Patricia" <pat777@hotmail.com>
Date: Tue, 25 Jun 2002 16:16:29 +0200

Adding to my previous post: it doesn't matter if they shut down the SQL
Server Agent. Once the trace is started it will continue independently from
the SQL Server Agent.

"Patricia" <pat777@hotmail.com> wrote in message
news:#4zDEHFHCHA.2488@tkmsftngp09...
> You can also create a job running this SP, and schedule the job to start
> every time SQL Server starts.
>
> "Toni Lassila" <mpao@mc-europe.com> wrote in message
> news:b11796dd.0206250254.e8e526e@posting.google.com...
> > Let's say I've used SQL Profiler to create an analysis trace for
> > security logging. I'd like to have a complete trace of things like
> > logins, GDR events and such. I've taken the script output from
> > SQL Profiler and created a stored procedure which is stored in
> > a database running under SQL Server. The trace when started
> > writes all the events to a disk file that is not accessible to other
> > accounts (possibly even encrypted).
> >
> > How do I set up SQL Server to automatically run my stored procedure
> > and start the trace everytime SQL Server starts? I can make it so
> > it starts everytime SQL Server Agent starts, but doing so will
> > enable the admin to shut down the Agent and do whatever they please.
> > Sure, the trace will show the Agent being shut down but that's it.
>
>

Relevant Pages

  • Re: User and Login auditing
    ... I am running SQL 7. ... You could put triggers on your trace table. ... How to Trace in SQL Server by Using Extended Stored ...
    (microsoft.public.sqlserver.security)
  • Re: Tracking user activities
    ... >> I'd like these settings to persist permanently and the event records to ... > In SQL 2000, this is not very simple to do. ... > Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... select Script Trace. ...
    (comp.databases.ms-sqlserver)
  • Re: How to look at parameter string
    ... I am tracing, but the problem I can't trace (at least, I haven't figured out ... string it is putting together to send to Sql. ... >> The problem is not coming from Sql Server but from my page. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: C2 SQL auditing
    ... Andrew J. Kelly SQL MVP ... Do you suggest any third party tools for SOX compliance? ... I would like to off load the server side trace to the SOX team ... when I stop SQL server then my trace file gets populated. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL logins logged where
    ... you can't trace directly to a table but can use the> fn_trace_gettable function to load the trace file into a> table. ... If you are using SQL Server 7, use> xp_trace_setqueuedestination to set the destination to a> table. ... Security Tab does not give too many ...
    (microsoft.public.sqlserver.security)
Quantcast