Prev: Speed Up OPENROWSET?
Next: Insert trigger
From: Joe K. on 1 Dec 2009 18:33

Is there away to number the query listed below using all of the SQL Server
Profiler traces in a directory?

select * FROM fn_trace_gettable ('\\servername\k$\trace\*.trc',DEFAULT)
where TextData IS NOT NULL

Please help me resolve this issue.
From: Andrew J. Kelly on 1 Dec 2009 20:35
Not quite sure what u mean by that but I assume you want to read all the
traces at once. If they were rollover files you simply specify the first one
in the batch and use the DEFAULT parameter (like you show) and it will read
them all. If they are different traces altogether and not rollovers I think
you need to read them one at a time. But u can try naming them with an _nnn
with sequential numbers and see if that works.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Joe K." <JoeK(a)discussions.microsoft.com> wrote in message
news:03B23E0A-8AC8-4D59-8659-3C1A9CAE0097(a)microsoft.com...
>
> Is there away to number the query listed below using all of the SQL Server
> Profiler traces in a directory?
>
> select * FROM fn_trace_gettable ('\\servername\k$\trace\*.trc',DEFAULT)
> where TextData IS NOT NULL
>
> Please help me resolve this issue.

 | 
Pages: 1
Prev: Speed Up OPENROWSET?
Next: Insert trigger