Re: Similar question about Auto Startup Trace
From: Harry G (anonymous_at_discussions.microsoft.com)
Date: 02/14/04
- Next message: rrookexperts_at_rogers.com: "Re: Report Server"
- Previous message: bscalzo: "New SQL Server tool"
- In reply to: Kalen Delaney: "Re: Similar question about Auto Startup Trace"
- Next in thread: Harry G: "Re: Similar question about Auto Startup Trace"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 14 Feb 2004 14:03:36 -0800
Thanks a lot Kalen, I will do it on Monday.
Harry
>-----Original Message-----
>Please take a look at the script created. There is a
place for you to
>specify the file to write to. You cannot save to a table
from a server side
>trace.
>AFTER you have tried this, and looked at the script
created, feel free to
>ask more questions.
>
>--
>HTH
>----------------
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>
>"Harry G" <anonymous@discussions.microsoft.com> wrote in
message
>news:107d501c3f30a$8dfe1f50$a601280a@phx.gbl...
>> If I script the trace like this, when the trace auto
>> started, it will auto write data to a file? because auto
>> write to a table or file is must in my case.
>>
>> Thank you so much for your help,
>> Harry
>>
>> >-----Original Message-----
>> >You should uncheck 'save to table' based on your
earlier
>> posts. It should be
>> >on the general definition page in the Profiler.
>> >
>> >--
>> >HTH
>> >----------------
>> >Kalen Delaney
>> >SQL Server MVP
>> >www.SolidQualityLearning.com
>> >
>> >
>> >"Harry G" <anonymous@discussions.microsoft.com> wrote
in
>> message
>> >news:1067901c3f2a3$c7525a80$a501280a@phx.gbl...
>> >> Kalen, Would you please tell me which option I should
>> >> uncheck it before I script the definition of the
trace
>> and
>> >> where is it?
>> >>
>> >> Thanks you,
>> >> Harry
>> >> >-----Original Message-----
>> >> >HI Harry
>> >> >
>> >> >The auto started trace should be writing to a file,
so
>> it
>> >> is auto saved
>> >> >there. You could create a job to stop the trace at
>> >> regular intervals (every
>> >> >hour?), close it, copy the file to a table, and the
>> >> restart the trace.
>> >> >
>> >> >--
>> >> >HTH
>> >> >----------------
>> >> >Kalen Delaney
>> >> >SQL Server MVP
>> >> >www.SolidQualityLearning.com
>> >> >
>> >> >
>> >> >"Harry G" <anonymous@discussions.microsoft.com>
wrote
>> in
>> >> message
>> >> >news:100e101c3f26c$e576be20$a401280a@phx.gbl...
>> >> >> Hi,
>> >> >>
>> >> >> After the trace auto startuped when SQL server
>> startup,
>> >> >> Is there any way to AUTO save the data into a
table
>> or
>> >> >> AUTO save the data into a file? Any ideas?
>> >> >>
>> >> >> Thanks in Advance,
>> >> >> Harry
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: rrookexperts_at_rogers.com: "Re: Report Server"
- Previous message: bscalzo: "New SQL Server tool"
- In reply to: Kalen Delaney: "Re: Similar question about Auto Startup Trace"
- Next in thread: Harry G: "Re: Similar question about Auto Startup Trace"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
