"MS" <M*@discussions.microsoft.com> wrote in message
news:301D495F-1B3F-4694-B9CA-6A3417F7CDEF@microsoft.com...
> Hello,
>
> How can I set SQL Profiler to capture the logs via command line? I wanted to
> this just before my testing.
>
> This is what I have:
>
> I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I
> need SQL to capture.
>
> C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE"
> /Sfoo  /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out
>
> What other parameters am I missing?
>
> Thanks!
>

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:OThA6%23tZHHA.1388@TK2MSFTNGP05.phx.gbl...
> Read up on "Server Side Trace".
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "MS" <M*@discussions.microsoft.com> wrote in message
> news:301D495F-1B3F-4694-B9CA-6A3417F7CDEF@microsoft.com...
>> Hello,
>>
>> How can I set SQL Profiler to capture the logs via command line? I wanted
>> to
>> this just before my testing.
>>
>> This is what I have:
>>
>> I already have a SQL Profiler Template (fooTemplate.tdf) which tells what
>> I
>> need SQL to capture.
>>
>> C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE"
>> /Sfoo  /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out
>>
>> What other parameters am I missing?
>>
>> Thanks!
>>
>

On 15 Mar, 14:14, "Hari Prasad" <hari_prasa***@hotmail.com> wrote:
> Read the below article aboutserverside tracing.
>
> http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
>
> http://www.dbazine.com/sql/sql-articles/larsen6
>
> THanks
> Hari
> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
> messagenews:OThA6%23tZHHA.1***@TK2MSFTNGP05.phx.gbl...
>
>
>
> > Read up on "ServerSide Trace".
>
> > --
> > Tibor Karaszi,SQLServerMVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://sqlblog.com/blogs/tibor_karaszi
>
> > "MS" <M***@discussions.microsoft.com> wrote in message
> >news:301D495F-1B3F-4694-B9CA-6A3417F7CDEF@microsoft.com...
> >> Hello,
>
> >> How can I setSQLProfilerto capture the logs viacommandline? I wanted
> >> to
> >> this just before my testing.
>
> >> This is what I have:
>
> >> I already have aSQLProfilerTemplate (fooTemplate.tdf) which tells what
> >> I
> >> needSQLto capture.
>
> >> C:\>"C:\Program Files\MicrosoftSQLServer\90\Tools\Binn\PROFILER90.EXE"
> >> /Sfoo  /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out
>
> >> What other parameters am I missing?
>
> >> Thanks!- Hide quoted text -
>
> - Show quoted text -