Re: Need help with Sql Profiler

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

Use sp_trace_create the @traceid is an output parameter. You use this
procedure to define the trace, create it, and get a handle to it.

You use sp_trace_set status to open it then start it. You must also stop it
and then close it to quit.

Sincerely,


Anthony Thomas


--

"Gene." <Gene@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A39584F9-A1A6-4A9C-890F-D86318471CCC@xxxxxxxxxxxxxxxx
Hello
I need to monitor creation/deletion/modification of objects in a database.
I decided to use sql profiler with objects events auditing(create, delete)
and TSQL events (SQL: STMstarting, SQL: batchstarting) for 'alter'
statement.
It's working, but I've encountered a few problems I can not resolve:
1. Template which I created does not remember 'save to table' settings. So
each time I restart - I need to specify them again.
2. I need to set it up with scheduler. I found sp_trace_setstatus proc but
it requires trace_id which I have no clue how to get.

Do I miss something about use of profiler?

Thank you, Gene.


.

Relevant Pages

  • RE: SQLXML problems
    ... If it is an SQL server's error ... Generally we can use SQL Profiler to do the trace. ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.data.oledb)
  • Re: SQL Profiler Filters
    ... I am had some problems with multiple filters working correctly together, ... There may be a bug in the trace ... If you are using SQL 2000, ... > Application Name Not Like SQL Profiler ...
    (microsoft.public.sqlserver.tools)
  • Re: Profiler logging SP:Starting hundreds of times for one SP
    ... However, when we trace it using SQL Profiler, it reports ... It looks like you have a function on a column in the query. ...
    (microsoft.public.sqlserver.tools)
  • Re: Access Linked server generates (Error 7399) - Help!
    ... See "Monitoring with SQL Profiler" in SQL Books Online, ... other applications running on the server. ... >> Did you try putting a SQL Profiler trace on the job? ...
    (microsoft.public.data.oledb)
  • Re: Need help with Sql Profiler
    ... server side traces (created with ... >I decided to use sql profiler with objects events auditing ... >and TSQL events ...
    (microsoft.public.sqlserver.tools)