Professional Web Applications Themes

**Tracing** - Microsoft SQL / MS SQL Server

Hi I use SQL Server 2000 and I try to trace and keep its result activities(by SQL Profiler and by T-SQL), now there's some question with me: how can I automatically start a trace everyday? I made a script on my trace information by SQl profiler but there was no topic related to the name of table kept my trace result,why? how can trace result be stored in different tables related to different days? in other word how can automatically change the name of table ,to keep the result of several days? -- Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]...

  1. #1

    Default **Tracing**

    Hi
    I use SQL Server 2000 and I try to trace and keep its result
    activities(by SQL Profiler and by T-SQL),
    now there's some question with me:
    how can I automatically start a trace everyday?
    I made a script on my trace information by SQl profiler
    but there was no topic related to the name of table kept
    my trace result,why?
    how can trace result be stored in different tables related to different
    days? in other word how can automatically
    change the name of table ,to keep the result of several days?

    --
    Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]
    M Guest

  2. #2

    Default Re: **Tracing**

    You can't save programmatically created traces to a table directly. They
    have to be saved to trace files, which you can ofcourse give a separate name
    for each day if you create a separate trace for each day.

    You can access the data in the trace file as a table with the function
    fn_trace_gettable.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "M" <mary2001canada.com> wrote in message
    news:oprrxqjo0ohu9gohmsnews.microsoft.com...
    > Hi
    > I use SQL Server 2000 and I try to trace and keep its result
    > activities(by SQL Profiler and by T-SQL),
    > now there's some question with me:
    > how can I automatically start a trace everyday?
    > I made a script on my trace information by SQl profiler
    > but there was no topic related to the name of table kept
    > my trace result,why?
    > how can trace result be stored in different tables related to different
    > days? in other word how can automatically
    > change the name of table ,to keep the result of several days?
    >
    > --
    > Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]

    Jacco Schalkwijk Guest

Similar Threads

  1. Question Tracing and Leading
    By Unregistered in forum Brainstorming Area
    Replies: 0
    Last Post: September 11th, 08:06 AM
  2. Tracing Bitmaps
    By Brian Dusablon in forum Macromedia Freehand
    Replies: 7
    Last Post: June 23rd, 08:16 AM
  3. Tracing
    By Margarett_H@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 2
    Last Post: June 3rd, 12:23 PM
  4. Tracing a Photo
    By Erin S. in forum Macromedia Freehand
    Replies: 2
    Last Post: March 1st, 07:54 PM
  5. Tracing, etc.
    By Econ Dev webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 2
    Last Post: January 18th, 05:20 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139