Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Arrow Unanswered: trace and 6.5---simple question--Tough answers

    I want to trace just sql statements, ie insert delete and update
    On d drive the file should be l dropped

    and have a fixed size say 1 mg

    How do i set up
    Last edited by sjumma; 03-23-04 at 14:51.
    bigfoots

  2. #2
    Join Date
    Oct 2003
    Posts
    232

    Hard to answer

    Hard to answer
    bigfoots

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662

    Re: trace and 6.5---simple question--Tough answers

    Originally posted by sjumma
    I want to trace just sql statements, ie insert delete and update
    On d drive the file should be l dropped

    and have a fixed size say 1 mg

    How do i set up
    You confused me with the "d drive" part of your question.

  4. #4
    Join Date
    Jan 2004
    Location
    Melbourne
    Posts
    11

    Re: trace and 6.5---simple question--Tough answers

    Use the SQL Profiler.

    Originally posted by sjumma
    I want to trace just sql statements, ie insert delete and update
    On d drive the file should be l dropped

    and have a fixed size say 1 mg

    How do i set up

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    In ver6.5 it is called as SQL Trace and not so friendly as compared to SQL PROFILER from ver.7.

    Take more information about SQL Trace.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Oct 2003
    Posts
    232

    well i know how to use the tracer

    I know how to use the sql 6.5 tracer but their is

    I cannot trace any sql statement even when the trace is on because of the vendor software that i run


    so is their a way that vendor can turn off the trace

    And by d drive i mean i want to drop the trace log on d drive
    bigfoots

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Do you mean the trace does not appear regardless where you run it from? Did you try to run the trace from the client, other than the server itself?

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    There is no setting in SQL to escape or mystify any activity while using PROFILER/Trace.

    As suggested its always better and suggested to use TRACE from a client machine. FOllow the link to capture the events listed.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •