RE: Trace file being imported to a table

From: Leon Parker (lparker@lortobco.com)
Date: 10/24/02 

From: "Leon Parker" <lparker@lortobco.com>
Date: Thu, 24 Oct 2002 08:15:12 -0700

I'm running SQL 2000. You do have the option to save to a
table using Profiler but I need to set up my trace audit
as a job which starts whenever SQL starts. In order for
me to do that I created my trace file in profiler and then
scripted it. Whenever you script within Profiler, the
script doesn't script saving the trace to a table. Do you
know of any way to do this? I know that I can use the
fn*gettable command to send my trace file to a table but
thats programmatically and I need for my table to be
updated automatically.
>-----Original Message-----
>Hi,
>
>Which Version of SQL Server are you using? I remember in
SQL Server 2000,
>you have the options to directly save the trace to a
table.
>
>Sincerely,
>
>David Wu
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Get Secure! ¨C www.microsoft.com/security
>
>
>.
>

Relevant Pages

  • Re: SQL 7 Traces
    ... Profiler 2K can generate the xp calls for a defined trace in 7 format. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Wartungsfreier SQL-Server!?
    ... wenn man sonst keine Anhaltspunkte hat. ... Wie kann ich den "SQL Profiler Trace" mir anzeigen lassen? ...
    (microsoft.public.de.sqlserver)
  • Re: Auditing sql server at runtime
    ... Use SQL Profiler to define your trace, ... User sp_procoption to mark the stored procedure for autoexecution when the SQL Server is restarted. ...
    (microsoft.public.sqlserver.clients)
  • Re: How to use xp_trace_generate_event
    ... Below is the script I am using: ... declare @QueueHandle int ... >>I have created a stored procedure that create a trace on SQL 7 and start ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Profiler Filters
    ... will only retrieve "UPDATE" SQL statements. ... Once you have created a trace and then ... How do you restart it so that you can continue tracing events. ... closed SQL Profiler before I went home last night ...
    (microsoft.public.sqlserver.tools)