Re: Need help to setup profiler at server side

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 12/29/04

  • Next message: swati: "Database Access (client) to Specific machines in LAN network." 
    Date: Tue, 28 Dec 2004 18:12:25 -0500

    Sunny wrote:
    > I have created one trace with Security Audits event only and about 10
    > data columns and no filter. Which runs fine SQL profiler. I just want
    > to trace users activity on server. But I want to keep this trace
    > running on the server. How can I setup to run trace on server from
    > client. I have admin rights on SQL 2000.

    Create a job in the SQL Server Agent to run the trace. Define the trace
    in Profiler at your client until you get the specs for the trace as you
    like them. Make sure you designate that the server should run the trace
    and specify a trace file (local to the server and in a folder the SQL
    Server Service Account has read/write access to). You can use rollover
    files if you want to. It's not necessary, but it will appear that the
    file is always 0MB until the trace is stopped. Run the trace, stop it,
    and then select the File - Script Trace menu option to script out the
    trace. Look over the generated code and test from Query Analyzer to make
    sure it is working as expected. Use the generated code in the job step.

    You'll need to stop the trace manually in order to see the results. You
    can write a stored procedure to do this using the sp_trace* system
    procedures. It could, for example, stop the trace, rename the trace
    file, and then start the job.

    To read the trace table or load into a table, you need to use
    fn_trace_gettable.

    You cannot trace directly to a table. 

    -- 
David Gugick
Imceda Software
www.imceda.com
  • Next message: swati: "Database Access (client) to Specific machines in LAN network."

    Relevant Pages

    • Re: User and Login auditing
      ... I agree 100% with Sue on not touching the system tables. ... > and hope that your employer doesn't mind you putting the SQL ... > Server box in this position. ... You could put triggers on your trace table. ...
      (microsoft.public.sqlserver.security)
    • Re: Problem with SQL Server [Solution]
      ... Apparently my sql server was not set to mixed mode authentication. ... > with the Trace Properties. ...
      (microsoft.public.dotnet.framework.adonet)
    • 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: Access Linked server generates (Error 7399 / 7312)
      ... I was thinking of SQL Profiler, which requires a sysadmin on the SQL ... Server box to set up and configure. ... If you could create a trace on ... >>>I restarted the jobs when the problem occured, ...
      (microsoft.public.data.oledb)
    • Re: URGENT deadlock question
      ... I have a deadlock template that I use with the following ... > SQL: Statement Completed ... > "Trace flags remain enabled in the server until disabled by executing ...
      (microsoft.public.sqlserver.server)